{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["Directions","Coral Assessment ","Sheet2","Sheet3","Justifications","Definitions","CompFcnServ","Risk Assessment","RA Numbers"],"not_rendered":{"charts":6,"images":3,"macros":0,"external_links":1,"defined_names":11,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Directions","index":0,"n_rows":36,"n_cols":4,"rows_kept":36,"cut":false,"hidden":false,"merged":[[32,3,32,10],[35,1,35,8],[20,3,26,10],[1,3,2,9],[7,3,10,10],[12,3,14,10],[15,3,18,10]]}
[]
[null,null,null,"Directions for using the US Army of Corps of Engineers Coral Ecological Services and Functions Assessment Tool"]
[]
[]
[]
[null,null,1,"Go to the  Coral Assessment  sheet."]
[]
[null,null,2,"Under Step 1, fill in all of the light yellow sections by typing within the light yellow portions. Note that Project Type is a pull-down menu where you select your answer. Also note that as you type in certain sections, white portions above will fill in automatically with a title for this project."]
[]
[]
[]
[]
[null,null,3,"Under Step 2, use the pull-down menu within the light yellow section to select a single sub-habitat on which the majority of corals you are assessing are (were) located."]
[]
[]
[null,null,4,"Save the Excel File as a unique file (using the titles provided in rows 2 and 3). This will allow the Master Copy to remain to be used for future runs of the tool without you having to erase everything."]
[]
[]
[]
[]
[null,null,5,"For Step 3, for each coral species you assess, fill in the number of colonies (whole numbers only) observed within each of the 7 size classess shown in columns C through I. The table to the right (Columns K through W) will fill in with the Ecological Charecterization values. To understand how these values are derived against the different growth forms, colony sizes, rarity, endemism and subhabitat types to which the colonies are attached, see the sheet entitled 'Justification'. You can also click on any of the cells within O22 to U89 to see the exact values used to derive the Ecological Charecterization value shown."]
[]
[]
[]
[]
[]
[]
[]
[null,null,6,"Under Step 4, data is summarized in various formats, including summarization charts to the right."]
[]
[null,null,7,"Go to the 'CompFcnServ' Sheet  to see how your results vary by the different ecological services and functions measured."]
[]
[]
[]
[]
[null,"Created by Dave Gulko 2023, after State of Hawaii version created by D Gulko (2016)."]

{"sheet":"Coral Assessment ","index":1,"n_rows":199,"n_cols":27,"rows_kept":199,"cut":false,"hidden":false,"merged":[[137,20,139,21],[0,0,0,6],[198,1,198,3],[11,4,11,11],[13,14,13,20],[184,20,186,21],[169,20,171,21],[153,20,155,21],[190,1,190,3],[185,1,186,2],[185,3,186,4],[182,1,182,2],[182,3,182,4],[188,1,188,3],[93,2,93,3],[93,7,93,8],[16,11,16,13],[5,2,5,3],[4,5,4,7],[17,24,19,24],[17,25,19,25],[17,26,19,26],[16,24,16,26],[1,1,1,4],[1,6,1,13],[6,2,6,3],[2,1,2,3],[2,5,2,10],[10,15,10,16],[9,15,9,16],[135,9,135,10],[133,9,134,10],[3,4,3,6],[9,6,9,8],[5,5,5,6],[93,9,93,10]]}
["US Army Corps of Engineers Coral Ecological Value Assessment Tool"]
[null,{"$f":"C6","v":0},null,null,null,"-",{"$f":"IF(D5<>\" \",_xlnm.Extract,\" \")","v":0}]
[null,{"$f":"IF(C12<>0,\"Man-Made Substrate\",IF(C13<>0,\"Altered Substrate\",IF(C14<>0,\"Natural Substrate\",\" \")))","v":" "},null,null,"-",{"$f":"IF(C12<>0,C12,IF(C13<>0,C13,IF(C14<>0,C14,\" \")))","v":" "}]
["Step 1","Directions: Fill in light yellow sections ONLY (and as applicable). Save as unique file to maintain master copy as template.",null,null,"Amount of bottom area damaged (or to be damaged), measured in acres",null,null,null,"acres","=",{"$f":"H4/0.000247","v":0},"m2"]
[null,"General Information","Project Type:",null,"Location:"]
[null,"Project Name:",null,null,"Depths:"]
[null,"Person Running the Assessment:",null,null,"Date Surveyed:",null,"to"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Common","Uncommon","Rare",null,"Endemic",null,"Subhabitat","Natural","Altered","Man-Made"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,2,3,null,2,null,null,{"$f":"IF(C14=\"\",0,IF(C14=\"Unconsolidated Substrate\",0.5,IF(C14=\"Boudler\",2,IF(C14=\"Solitary Colony\",1,IF(C14=\"Aggregated Colonies\",2,IF(C14=\"Reef Flat\",4,5))))))","v":0},{"$f":"IF(C13=\"\",0,IF(C13=\"Ship Channel Bottom\",0.5,IF(C13=\"Ship Channel Walls\",1,IF(C13=\"Grounding Scar or Anchorage\",1,IF(C13=\"Natural Modified Harbor Walls\",2,IF(C13=\"Longterm Outfall or Dump Site\",0.5,0.5))))))","v":0},{"$f":"IF(C12=\"\",0,IF(C12=\"Artificial Reef\",1,IF(C12=\"Pile or Column\",0.5,IF(C12=\"Breakwater\",2,IF(C12=\"Other\",0.5,IF(C12=\"Submerged Debris\",0.5,1))))))","v":0}]
[null,null,null,null,null,null,"Coral Colony Characterization  Formula Information",null,null,null,null,null,null,null,"Habitat","Subhabitat Type Selected",null,null,"Non-Endemic"]
["Step 2","Habitat Type/Subhabitat Type                                                                                     (Choose only one below by selecting the associated subhabitat to the right)->)",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Sheet3!D37","v":0},{"$f":"F3","v":" "},null,null,1]
[null,"Coral Colonies on Man-Made Substrates",null,null,"Ecological Characterization Value (ECV)  = Subhabitat(Habitat) x Colony Size(n) x Rarity x Form x Endemism"]
[null,"Coral Colonies on Altered Substrates"]
[null,"Coral Colonies on Natural Substrates",null,null,null,null,null,null,null,null,null,null,null,null,"Ecological Services & Functional Values (ECV)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Y","Y","Y","A","A","SA","SA"]
["Step 3","Coral Species Encountered",null,null,null,null,null,null,null,null,null,null,null,null,"0 - 5 cm",">5 - 10 cm",">10 - 20 cm",">20 - 40cm",">40 - 80 cm",">80 - 160 cm",">160 cm"]
[null,"Colony Size","0 - 5 cm",">5 - 10 cm",">10 - 20 cm",">20 - 40cm",">40 - 80 cm",">80 - 160 cm",">160 cm",null,"MHI"," Growth Form",null,null,0.25,0.5,2,5,20,100,500,null,null,null,"Shannon-Weiner Diversity Index"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Encrusting","Solitary","Branching","Free-Living","Plate","Digiform","Massive","Table","Foliaceus",null,"Total Colonies per species","Proportion (Pi)","Pi*(LN(Pi))"]
[null,null,null,null,null,null,null,null,null,null,null,"Y","A","SA"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,1,4,1,3,4,5,5,4]
[null,"f. Pocilloporidae",null,null,null,null,null,null,null,null,null,null,null,null,"0 - <5 cm","5 - <10 cm","10 - <20 cm","20 - <40cm","40 - <80 cm","80 - <160 cm","160 cm +"]
[null,"Pocillopora damicornis",null,null,null,null,null,null,null,null,"Uncommon",null,null,null,{"$f":"O11*(C22*Q20*P9*O17)","v":0},{"$f":"O11*(D22*Q20*P9*P17)","v":0},{"$f":"O11*(E22*Q20*P9*Q17)","v":0},{"$f":"O11*(F22*Q20*P9*R17)","v":0},{"$f":"O11*(G22*Q20*P9*S17)","v":0},{"$f":"O11*(H22*Q20*P9*T17)","v":0},null,null,null,null,{"$f":"SUM(C22:H22)","v":0},{"$f":"IF(Y22<>0,Y22/SUM(Y$22:Y$89),\"\")","v":""},{"$f":"IF(Z22<>\"\",Z22*(LN(Z22)),\"\")","v":""}]
[null,"Pocillopora eydouxi",null,null,null,null,null,null,null,null,"Uncommon",null,null,null,{"$f":"O11*(C23*Q20*P9*O17)","v":0},{"$f":"O11*(D23*Q20*P9*P17)","v":0},{"$f":"O11*(E23*Q20*P9*Q17)","v":0},{"$f":"O11*(F23*Q20*P9*R17)","v":0},{"$f":"O11*(G23*Q20*P9*S17)","v":0},{"$f":"O11*(H23*Q20*P9*T17)","v":0},null,null,null,null,{"$f":"SUM(C23:H23)","v":0},{"$f":"IF(Y23<>0,Y23/SUM(Y$22:Y$89),\"\")","v":""},{"$f":"IF(Z23<>\"\",Z23*(LN(Z23)),\"\")","v":""}]
[null,"Pocillopora ligulata",null,null,null,null,null,null,null,null,"Rare",null,null,null,{"$f":"O11*(C24*Q20*Q9*O17)","v":0},{"$f":"O11*(D24*Q20*Q9*P17)","v":0},{"$f":"O11*(E24*Q20*Q9*Q17)","v":0},{"$f":"O11*(F24*Q20*Q9*R17)","v":0},{"$f":"O11*(G24*Q20*Q9*S17)","v":0},{"$f":"O11*(H24*Q20*Q9*T17)","v":0},null,null,null,null,0,"",""]
[null,"Pocillopora meandrina",null,null,null,null,null,null,null,null,"Common",null,null,null,{"$f":"O11*(C25*Q20*O9*O17)","v":0},{"$f":"O11*(D25*Q20*O9*P17)","v":0},{"$f":"O11*(E25*Q20*O9*Q17)","v":0},{"$f":"O11*(F25*Q20*O9*R17)","v":0},{"$f":"O11*(G25*Q20*O9*S17)","v":0},{"$f":"O11*(H25*Q20*O9*T17)","v":0},null,null,null,null,0,"",""]
[null,"Pocillopora molokensis",null,null,null,null,null,null,null,null,"Rare",null,null,null,{"$f":"O11*(C26*Q20*Q9*O17)*S9","v":0},{"$f":"O11*(D26*Q20*Q9*P17)*S9","v":0},{"$f":"O11*(E26*Q20*Q17*Q9)*S9","v":0},{"$f":"O11*(F26*Q20*Q9*R17)*S9","v":0},{"$f":"O11*(G26*Q20*Q9*S17)*S9","v":0},{"$f":"O11*(H26*Q20*Q9*T17)*S9","v":0},null,null,null,null,0,"",""]
[null,"f. Acroporidae"]
[null,"Montipora capitata",null,null,null,null,null,null,null,null,"Common",null,null,null,{"$f":"O11*(C28*O20*O9*O17)*S9","v":0},{"$f":"O11*(D28*O20*O9*P17)*S9","v":0},{"$f":"O11*(E28*O20*O9*Q17)*S9","v":0},{"$f":"O11*(F28*S20*O9*R17)*S9","v":0},{"$f":"O11*(G28*S20*O9*S17)*S9","v":0},{"$f":"O11*(H28*S20*O9*T17)*S9","v":0},{"$f":"O11*(I28*S20*O9*U17)*S9","v":0},null,null,null,0,"",""]
[null,"Montipora dilitata",null,null,null,null,null,null,null,null,"Rare",null,null,null,{"$f":"O11*(C29*O20*Q9*O17)*S9","v":0},{"$f":"O11*(D29*O20*Q9*P17)*S9","v":0},{"$f":"O11*(E29*O20*Q9*Q17)*S9","v":0},{"$f":"O11*(F29*T20*Q9*R17)*S9","v":0},{"$f":"O11*(G29*T20*Q9*S17)*S9","v":0},{"$f":"O11*(H29*T20*Q9*T17)*S9","v":0},{"$f":"O11*(I29*T20*Q9*U17)*S9","v":0},null,null,null,0,"",""]
[null,"Montipora flabellata",null,null,null,null,null,null,null,null,"Uncommon",null,null,null,{"$f":"O11*(C30*O20*P9*O17)*S9","v":0},{"$f":"O11*(D30*O20*P9*P17)*S9","v":0},{"$f":"O11*(E30*O20*P9*Q17)*S9","v":0},{"$f":"O11*(F30*O20*P9*R17)*S9","v":0},{"$f":"O11*(G30*O20*P9*S17)*S9","v":0},{"$f":"O11*(H30*O20*P9*T17)*S9","v":0},{"$f":"O11*(I30*O20*P9*U17)*S9","v":0},null,null,null,0,"",""]
[null,"Montipora incrassata",null,null,null,null,null,null,null,null,"Rare",null,null,null,{"$f":"O11*(C31*T20*Q9*O17)","v":0},{"$f":"O11*(D31*T20*Q9*P17)","v":0},{"$f":"O11*(E31*T20*Q9*Q17)","v":0},{"$f":"O11*(F31*T20*Q9*R17)","v":0},{"$f":"O11*(G31*T20*Q9*S17)","v":0},{"$f":"O11*(H31*T20*Q9*T17)","v":0},{"$f":"O11*(I31*T20*Q9*U17)","v":0},null,null,null,0,"",""]
[null,"Montipora patula",null,null,null,null,null,null,null,null,"Common",null,null,null,{"$f":"O11*(C32*O20*O9*O17)*S9","v":0},{"$f":"O11*(D32*O20*O9*P17)*S9","v":0},{"$f":"O11*(E32*O20*O9*Q17)*S9","v":0},{"$f":"O11*(F32*O20*O9*R17)*S9","v":0},{"$f":"O11*(G32*O20*O9*S17)*S9","v":0},{"$f":"O11*(H32*O20*O9*T17)*S9","v":0},{"$f":"O11*(I32*O20*O9*U17)*S9","v":0},null,null,null,0,"",""]
[null,"Montipora turgescens",null,null,null,null,null,null,null,null,"Rare",null,null,null,{"$f":"O11*(C33*O20*Q9*O17)","v":0},{"$f":"O11*(D33*O20*Q9*P17)","v":0},{"$f":"O11*(E33*O20*Q9*Q17)","v":0},{"$f":"O11*(F33*O20*Q9*R17)","v":0},{"$f":"O11*(G33*O20*Q9*S17)","v":0},{"$f":"O11*(H33*O20*Q9*T17)","v":0},{"$f":"O11*(I33*O20*Q9*U17)","v":0},null,null,null,0,"",""]
[]
[null,"Acropora spp.",null,null,null,null,null,null,null,null,"Rare",null,null,null,{"$f":"O11*(C35*V20*Q9*O17)","v":0},{"$f":"O11*(D35*V20*Q9*P17)","v":0},{"$f":"O11*(E35*V20*Q9*Q17)","v":0},{"$f":"O11*(F35*V20*Q9*R17)","v":0},{"$f":"O11*(G35*V20*Q9*S17)","v":0},{"$f":"O11*(H35*V20*Q9*T17)","v":0},{"$f":"O11*(I35*V20*Q9*U17)","v":0},null,null,null,0,"",""]
[null,"f. Poritidae"]
[null,"Porites annae",null,null,null,null,null,null,null,null,"Rare",null,null,null,{"$f":"O11*(C37*U20*Q9*O17)*S9","v":0},{"$f":"O11*(D37*U20*Q9*P17)*S9","v":0},{"$f":"O11*(E37*U20*Q9*Q17)*S9","v":0},{"$f":"O11*(F37*U20*Q9*R17)*S9","v":0},{"$f":"O11*(G37*U20*Q9*S17)*S9","v":0},{"$f":"O11*(H37*U20*Q9*T17)*S9","v":0},{"$f":"O11*(I37*U20*Q9*U17)*S9","v":0},null,null,null,0,"",""]
[null,"Porites bernardi",null,null,null,null,null,null,null,null,"Uncommon",null,null,null,{"$f":"O11*(C38*O20*P9*O17)","v":0},{"$f":"O11*(C38*O20*P9*P17)","v":0},{"$f":"O11*(E38*O20*P9*Q17)","v":0},null,null,null,null,null,null,null,0,"",""]
[null,"Porites brighami",null,null,null,null,null,null,null,null,"Uncommon",null,null,null,{"$f":"O11*(C39*U20*P9*O17)*S9","v":0},{"$f":"O11*(D39*U20*P9*P17)*S9","v":0},{"$f":"O11*(E39*U20*P9*Q17)*S9","v":0},{"$f":"O11*(F39*U20*P9*R17)*S9","v":0},{"$f":"O11*(G39*U20*P9*S17)*S9","v":0},null,null,null,null,null,0,"",""]
[null,"Porites compressa",null,null,null,null,null,null,null,null,"Common",null,null,null,{"$f":"O11*(C40*T20*O9*O17)*S9","v":0},{"$f":"O11*(D40*T20*O9*P17)*S9","v":0},{"$f":"O11*(E40*T20*O9*Q17)*S9","v":0},{"$f":"O11*(F40*T20*O9*R17)*S9","v":0},{"$f":"O11*(G40*T20*O9*S17)*S9","v":0},{"$f":"O11*(H40*T20*O9*T17)*S9","v":0},{"$f":"O11*(I40*T20*O9*U17)*S9","v":0},null,null,null,0,"",""]
[null,"Porites duerdeni",null,null,null,null,null,null,null,null,"Rare",null,null,null,{"$f":"O11*(C41*T20*Q9*O17)*S9","v":0},{"$f":"O11*(D41*T20*Q9*P17)*S9","v":0},{"$f":"O11*(E41*T20*Q9*Q17)*S9","v":0},{"$f":"O11*(F41*T20*Q9*R17)*S9","v":0},{"$f":"O11*(G41*T20*Q9*S17)*S9","v":0},{"$f":"O11*(H41*T20*Q9*T17)*S9","v":0},{"$f":"O11*(I41*T20*Q9*U17)*S9","v":0},null,null,null,0,"",""]
[null,"Porites lichen",null,null,null,null,null,null,null,null,"Rare",null,null,null,{"$f":"O11*(C42*O20*Q9*O17)","v":0},{"$f":"O11*(D42*O20*Q9*P17)","v":0},{"$f":"O11*(E42*O20*Q9*Q17)","v":0},{"$f":"O11*(F42*O20*Q9*R17)","v":0},{"$f":"O11*(G42*O20*Q9*S17)","v":0},{"$f":"O11*(H42*O20*Q9*T17)","v":0},{"$f":"O11*(I42*O20*Q9*U17)","v":0},null,null,null,0,"",""]
[null,"Porites lobata",null,null,null,null,null,null,null,null,"Common",null,null,null,{"$f":"O11*(C43*U20*O9*O17)","v":0},{"$f":"O11*(D43*U20*O9*P17)","v":0},{"$f":"O11*(E43*U20*O9*Q17)","v":0},{"$f":"O11*(F43*U20*O9*R17)","v":0},{"$f":"O11*(G43*U20*O9*S17)","v":0},{"$f":"O11*(H43*U20*O9*T17)","v":0},{"$f":"O11*(I43*U20*O9*U17)","v":0},null,null,null,0,"",""]
[null,"Porites evermanni",null,null,null,null,null,null,null,null,"Uncommon",null,null,null,{"$f":"O11*(C44*U20*P9*O17)*S9","v":0},{"$f":"O11*(D44*U20*P9*P17)*S9","v":0},{"$f":"O11*(E44*U20*P9*Q17)*S9","v":0},{"$f":"O11*(F44*U20*P9*R17)*S9","v":0},{"$f":"O11*(G44*U20*P9*S17)*S9","v":0},{"$f":"O11*(H44*U20*P9*T17)*S9","v":0},{"$f":"O11*(I44*U20*P9*U17)*S9","v":0},null,null,null,0,"",""]
[null,"Porites monticulosa",null,null,null,null,null,null,null,null,"Uncommon",null,null,null,{"$f":"O11*(C45*S20*P9*O17)","v":0},{"$f":"O11*(D45*S20*P9*P17)","v":0},{"$f":"O11*(E45*S20*P9*Q17)","v":0},{"$f":"O11*(F45*S20*P9*R17)","v":0},{"$f":"O11*(G45*S20*P9*S17)","v":0},{"$f":"O11*(H45*S20*P9*T17)","v":0},{"$f":"O11*(I45*S20*P9*U17)","v":0},null,null,null,0,"",""]
[null,"Porites pukoensis",null,null,null,null,null,null,null,null,"Rare",null,null,null,{"$f":"O11*(C46*T20*Q9*O17)*S9","v":0},{"$f":"O11*(D46*T20*Q9*P17)*S9","v":0},{"$f":"O11*(E46*T20*Q9*Q17)*S9","v":0},{"$f":"O11*(F46*T20*Q9*R17)*S9","v":0},{"$f":"O11*(G46*T20*Q9*S17)*S9","v":0},{"$f":"O11*(H46*T20*Q9*T17)*S9","v":0},{"$f":"O11*(I46*T20*Q9*U17)*S9","v":0},null,null,null,0,"",""]
[null,"Porites rus",null,null,null,null,null,null,null,null,"Uncommon",null,null,null,{"$f":"O11*(C47*T20*P9*O17)","v":0},{"$f":"O11*(D47*T20*P9*P17)","v":0},{"$f":"O11*(E47*T20*P9*Q17)","v":0},{"$f":"O11*(F47*T20*P9*R17)","v":0},{"$f":"O11*(G47*T20*P9*S17)","v":0},{"$f":"O11*(H47*T20*P9*T17)","v":0},{"$f":"O11*(I47*T20*P9*U17)","v":0},null,null,null,0,"",""]
[null,"Porites solida",null,null,null,null,null,null,null,null,"Uncommon",null,null,null,{"$f":"O11*(C48*U20*P9*O17)","v":0},{"$f":"O11*(D48*U20*P9*P17)","v":0},{"$f":"O11*(E48*U20*P9*Q17)","v":0},{"$f":"O11*(F48*U20*P9*R17)","v":0},{"$f":"O11*(G48*U20*P9*S17)","v":0},{"$f":"O11*(H48*U20*P9*T17)","v":0},{"$f":"O11*(I48*U20*P9*U17)","v":0},null,null,null,0,"",""]
[null,"Porites studeri",null,null,null,null,null,null,null,null,"Uncommon",null,null,null,{"$f":"O11*(C49*U20*P9*O17)","v":0},{"$f":"O11*(D49*U20*P9*P17)","v":0},{"$f":"O11*(E49*U20*P9*Q17)","v":0},{"$f":"O11*(F49*U20*P9*R17)","v":0},{"$f":"O11*(G49*U20*P9*S17)","v":0},null,null,null,null,null,0,"",""]
[null,"f. Siderastreadae"]
[null,"Psammocora explanulata",null,null,null,null,null,null,null,null,"Rare",null,null,null,{"$f":"O11*(C51*O20*Q9*O17)","v":0},{"$f":"O11*(D51*O20*Q9*P17)","v":0},{"$f":"O11*(E51*O20*Q9*Q17)","v":0},{"$f":"O11*(F51*O20*Q9*R17)","v":0},{"$f":"O11*(G51*O20*Q9*S17)","v":0},{"$f":"O11*(H51*O20*Q9*T17)","v":0},{"$f":"O11*(I51*O20*Q9*U17)","v":0},null,null,null,0,"",""]
[null,"Psammocora haimeana",null,null,null,null,null,null,null,null,"Rare",null,null,null,{"$f":"O11*(C52*O20*Q9*O17)","v":0},{"$f":"O11*(D52*O20*Q9*P17)","v":0},{"$f":"O11*(E52*O20*Q9*Q17)","v":0},{"$f":"O11*(F52*O20*Q9*R17)","v":0},{"$f":"O11*(G52*O20*Q9*S17)","v":0},{"$f":"O11*(H52*O20*Q9*T17)","v":0},{"$f":"O11*(I52*O20*Q9*U17)","v":0},null,null,null,0,"",""]
[null,"Psammocora nierstraszi",null,null,null,null,null,null,null,null,"Uncommon",null,null,null,{"$f":"O11*(C53*O20*P9*O17)","v":0},{"$f":"O11*(D53*O20*P9*P17)","v":0},{"$f":"O11*(E53*O20*P9*Q17)","v":0},{"$f":"O11*(F53*O20*P9*R17)","v":0},{"$f":"O11*(G53*O20*P9*S17)","v":0},{"$f":"O11*(H53*O20*P9*T17)","v":0},{"$f":"O11*(I53*O20*P9*U17)","v":0},null,null,null,0,"",""]
[null,"Psammocora stellata",null,null,null,null,null,null,null,null,"Uncommon",null,null,null,{"$f":"O11*(C54*Q20*P9*O17)","v":0},{"$f":"O11*(D54*Q20*P9*P17)","v":0},{"$f":"O11*(E54*Q20*P9*Q17)","v":0},null,null,null,null,null,null,null,0,"",""]
[null,"Psammocora superficialis",null,null,null,null,null,null,null,null,"Rare",null,null,null,{"$f":"O11*(C55*O20*Q9*O17)","v":0},{"$f":"O11*(D55*O20*Q9*P17)","v":0},{"$f":"O11*(E55*O20*Q9*Q17)","v":0},{"$f":"O11*(F55*O20*Q9*R17)","v":0},{"$f":"O11*(G55*O20*Q9*S17)","v":0},{"$f":"O11*(H55*O20*Q9*T17)","v":0},{"$f":"O11*(I55*O20*Q9*U17)","v":0},null,null,null,0,"",""]
[null,"Psammocora verrili",null,null,null,null,null,null,null,null,"Rare",null,null,null,{"$f":"O11*(C56*O20*Q9*O17)*S9","v":0},{"$f":"O11*(D56*O20*Q9*P17)*S9","v":0},{"$f":"O11*(E56*O20*Q9*Q17)*S9","v":0},{"$f":"O11*(F56*O20*Q9*R17)*S9","v":0},{"$f":"O11*(G56*O20*Q9*S17)*S9","v":0},{"$f":"O11*(H56*O20*Q9*T17)*S9","v":0},{"$f":"O11*(I56*O20*Q9*U17)*S9","v":0},null,null,null,0,"",""]
[null,"Coscinaraea wellsi",null,null,null,null,null,null,null,null,"Rare",null,null,null,{"$f":"O11*(C57*O20*Q9*O17)","v":0},{"$f":"O11*(D57*O20*Q9*P17)","v":0},{"$f":"O11*(E57*O20*Q9*Q17)","v":0},{"$f":"O11*(F57*O20*Q9*R17)","v":0},{"$f":"O11*(G57*O20*Q9*S17)","v":0},null,null,null,null,null,0,"",""]
[null,"f. Agariciidae"]
[null,"Pavona duerdeni",null,null,null,null,null,null,null,null,"Uncommon",null,null,null,{"$f":"O11*(C59*U20*P9*O17)","v":0},{"$f":"O11*(D59*U20*P9*P17)","v":0},{"$f":"O11*(E59*U20*P9*Q17)","v":0},{"$f":"O11*(F59*U20*P9*R17)","v":0},{"$f":"O11*(G59*U20*P9*S17)","v":0},{"$f":"O11*(H59*U20*P9*T17)","v":0},{"$f":"O11*(I59*U20*P9*U17)","v":0},null,null,null,0,"",""]
[null,"Pavona maldivensis",null,null,null,null,null,null,null,null,"Rare",null,null,null,{"$f":"O11*(C60*O20*Q9*O17)","v":0},{"$f":"O11*(D60*O20*Q9*P17)","v":0},{"$f":"O11*(E60*O20*Q9*Q17)","v":0},{"$f":"O11*(F60*O20*Q9*R17)","v":0},{"$f":"O11*(G60*O20*Q9*S17)","v":0},{"$f":"O11*(H60*O20*Q9*T17)","v":0},{"$f":"O11*(I60*O20*Q9*U17)","v":0},null,null,null,0,"",""]
[null,"Pavona varians",null,null,null,null,null,null,null,null,"Common",null,null,null,{"$f":"O11*(C61*O20*O9*O17)","v":0},{"$f":"O11*(D61*O20*O9*P17)","v":0},{"$f":"O11*(E61*O20*O9*Q17)","v":0},{"$f":"O11*(F61*O20*O9*R17)","v":0},{"$f":"O11*(G61*O20*O9*S17)","v":0},{"$f":"O11*(H61*O20*O9*T17)","v":0},{"$f":"O11*(I61*O20*O9*U17)","v":0},null,null,null,0,"",""]
[]
[null,"Leptoseris foliosa",null,null,null,null,null,null,null,null,"Rare",null,null,null,{"$f":"O11*(C63*W20*Q9*O17)","v":0},{"$f":"O11*(D63*W20*Q9*P17)","v":0},{"$f":"O11*(E63*W20*Q9*Q17)","v":0},{"$f":"O11*(E63*W20*Q9*R17)","v":0},{"$f":"O11*(G63*W20*Q9*S17)","v":0},null,null,null,null,null,0,"",""]
[null,"Leptoseris hawaiiensis",null,null,null,null,null,null,null,null,"Rare",null,null,null,{"$f":"O11*(C64*O20*Q9*O17)","v":0},{"$f":"O11*(D64*O20*Q9*P17)","v":0},{"$f":"O11*(E64*O20*Q9*Q17)","v":0},{"$f":"O11*(F64*O20*Q9*R17)","v":0},{"$f":"O11*(G64*O20*Q9*S17)","v":0},{"$f":"O11*(H64*O20*Q9*T17)","v":0},{"$f":"O11*(I64*O20*Q9*U17)","v":0},null,null,null,0,"",""]
[null,"Leptoseris incrustans",null,null,null,null,null,null,null,null,"Common",null,null,null,{"$f":"O11*(C65*O20*O9*O17)","v":0},{"$f":"O11*(D65*O20*O9*P17)","v":0},{"$f":"O11*(E65*O20*O9*Q17)","v":0},{"$f":"O11*(F65*O20*O9*R17)","v":0},{"$f":"O11*(G65*O20*O9*S17)","v":0},{"$f":"O11*(H65*O20*O9*T17)","v":0},{"$f":"O11*(I65*O20*O9*U17)","v":0},null,null,null,0,"",""]
[null,"Leptoseris mycetoseroides",null,null,null,null,null,null,null,null,"Rare",null,null,null,{"$f":"O11*(C66*O20*Q9*O17)","v":0},{"$f":"O11*(D66*O20*Q9*P17)","v":0},{"$f":"O11*(E66*O20*Q9*Q17)","v":0},{"$f":"O11*(F66*O20*Q9*R17)","v":0},{"$f":"O11*(G66*O20*Q9*S17)","v":0},{"$f":"O11*(H66*O20*Q9*T17)","v":0},{"$f":"O11*(I66*O20*Q9*U17)","v":0},null,null,null,0,"",""]
[null,"Leptoseris papyracea",null,null,null,null,null,null,null,null,"Rare",null,null,null,{"$f":"O11*(C67*W20*Q9*O17)","v":0},{"$f":"O11*(D67*W20*Q9*P17)","v":0},{"$f":"O11*(E67*W20*Q9*Q17)","v":0},{"$f":"O11*(F67*W20*Q9*R17)","v":0},{"$f":"O11*(G67*W20*Q9*S17)","v":0},null,null,null,null,null,0,"",""]
[null,"Leptoseris scabra",null,null,null,null,null,null,null,null,"Rare",null,null,null,{"$f":"O11*(C68*W20*Q9*O17)","v":0},{"$f":"O11*(D68*W20*Q9*P17)","v":0},{"$f":"O11*(E68*W20*Q9*Q17)","v":0},{"$f":"O11*(F68*W20*Q9*R17)","v":0},{"$f":"O11*(G68*W20*Q9*S17)","v":0},null,null,null,null,null,0,"",""]
[null,"Leptoseris tubulifera",null,null,null,null,null,null,null,null,"Uncommon",null,null,null,{"$f":"O11*(C69*W20*P9*O17)","v":0},{"$f":"O11*(D69*W20*P9*P17)","v":0},{"$f":"O11*(E69*W20*P9*Q17)","v":0},{"$f":"O11*(F69*W20*P9*R17)","v":0},{"$f":"O11*(G69*W20*P9*S17)","v":0},null,null,null,null,null,0,"",""]
[null,"Gardineroseris planulata",null,null,null,null,null,null,null,null,"Rare",null,null,null,{"$f":"O11*(C70*U20*Q9*O17)","v":0},{"$f":"O11*(D70*U20*Q9*P17)","v":0},{"$f":"O11*(E70*U20*Q9*Q17)","v":0},{"$f":"O11*(F70*U20*Q9*R17)","v":0},{"$f":"O11*(G70*U20*Q9*S17)","v":0},{"$f":"O11*(H70*U20*Q9*T17)","v":0},{"$f":"O11*(I70*U20*Q9*U17)","v":0},null,null,null,0,"",""]
[null,"f. Fungiidae"]
[null,"Cycloseris vaughani",null,null,null,null,null,null,null,null,"Uncommon",null,null,null,{"$f":"O11*(C72*R20*P9*O17)","v":0},{"$f":"O11*(D72*R20*P9*P17)","v":0},{"$f":"O11*(E72*R20*P9*Q17)","v":0},null,null,null,null,null,null,null,0,"",""]
[null,"Diaseris distorta",null,null,null,null,null,null,null,null,"Rare",null,null,null,{"$f":"O11*(C73*R20*Q9*O17)","v":0},{"$f":"O11*(D73*R20*Q9*P17)","v":0},{"$f":"O11*(E73*R20*Q9*Q17)","v":0},null,null,null,null,null,null,null,0,"",""]
[null,"Diaseris fragilis",null,null,null,null,null,null,null,null,"Rare",null,null,null,{"$f":"O11*(C74*R20*Q9*O17)","v":0},{"$f":"O11*(D74*R20*Q9*P17)","v":0},{"$f":"O11*(E74*R20*Q9*Q17)","v":0},null,null,null,null,null,null,null,0,"",""]
[null,"Fungia granulosa",null,null,null,null,null,null,null,null,"Uncommon",null,null,null,{"$f":"O11*(C75*R20*P9*O17)","v":0},{"$f":"O11*(D75*R20*P9*P17)","v":0},{"$f":"O11*(E75*R20*P9*Q17)","v":0},{"$f":"O11*(F75*R20*P9*R17)","v":0},{"$f":"O11*(F75*R20*P9*S17)","v":0},null,null,null,null,null,0,"",""]
[null,"Fungia scutaria",null,null,null,null,null,null,null,null,"Common",null,null,null,{"$f":"O11*(C76*R20*O9*O17)","v":0},{"$f":"O11*(D76*R20*O9*P17)","v":0},{"$f":"O11*(E76*R20*O9*Q17)","v":0},{"$f":"O11*(F76*R20*O9*R17)","v":0},{"$f":"O11*(F76*R20*O9*S17)","v":0},null,null,null,null,null,0,"",""]
[null,"f. Faviidae"]
[null,"Leptastrea bewickensis",null,null,null,null,null,null,null,null,"Uncommon",null,null,null,{"$f":"O11*(C78*O20*P9*O17)","v":0},{"$f":"O11*(D78*O20*P9*P17)","v":0},{"$f":"O11*(E78*O20*P9*Q17)","v":0},{"$f":"O11*(F78*O20*P9*R17)","v":0},{"$f":"O11*(G78*O20*P9*S17)","v":0},{"$f":"O11*(H78*O20*P9*T17)","v":0},{"$f":"O11*(I78*O20*P9*U17)","v":0},null,null,null,0,"",""]
[null,"Leptastrea purpurea",null,null,null,null,null,null,null,null,"Rare",null,null,null,{"$f":"O11*(C79*O20*Q9*O17)","v":0},{"$f":"O11*(D79*O20*Q9*P17)","v":0},{"$f":"O11*(E79*O20*Q9*Q17)","v":0},{"$f":"O11*(F79*O20*Q9*R17)","v":0},{"$f":"O11*(G79*O20*Q9*S17)","v":0},{"$f":"O11*(H79*O20*Q9*T17)","v":0},{"$f":"O11*(I79*O20*Q9*U17)","v":0},null,null,null,0,"",""]
[null,"Leptastrea transversa",null,null,null,null,null,null,null,null,"Uncommon",null,null,null,{"$f":"O11*(C80*O20*P9*O17)","v":0},{"$f":"O11*(D80*O20*P9*P17)","v":0},{"$f":"O11*(E80*O20*P9*Q17)","v":0},{"$f":"O11*(F80*O20*P9*R17)","v":0},{"$f":"O11*(G80*O20*P9*S17)","v":0},null,null,null,null,null,0,"",""]
[null,"Leptastrea pruinosa",null,null,null,null,null,null,null,null,"Rare",null,null,null,{"$f":"O11*(C81*O20*Q9*O17)","v":0},{"$f":"O11*(D81*O20*Q9*P17)","v":0},{"$f":"O11*(E81*O20*Q9*Q17)","v":0},{"$f":"O11*(F81*O20*Q9*R17)","v":0},{"$f":"O11*(G81*O20*Q9*S17)","v":0},{"$f":"O11*(H81*O20*Q9*T17)","v":0},{"$f":"O11*(I81*O20*Q9*U17)","v":0},null,null,null,0,"",""]
[null,"Cyphastrea agassizi",null,null,null,null,null,null,null,null,"Uncommon",null,null,null,{"$f":"O11*(C82*O20*P9*O17)","v":0},{"$f":"O11*(D82*O20*P9*P17)","v":0},{"$f":"O11*(E82*O20*P9*Q17)","v":0},null,null,null,null,null,null,null,0,"",""]
[null,"Cyphastrea ocellina",null,null,null,null,null,null,null,null,"Common",null,null,null,{"$f":"O11*(C83*O20*O9*O17)","v":0},{"$f":"O11*(D83*O20*O9*P17)","v":0},{"$f":"O11*(E83*O20*O9*Q17)","v":0},null,null,null,null,null,null,null,0,"",""]
[null,"f. Dendrophyllidae"]
[null,"Tubastraea coccinea",null,null,null,null,null,null,null,null,"Common",null,null,null,{"$f":"O11*(C85*P20*O9*O17)","v":0},{"$f":"O11*(D85*P20*O9*P17)","v":0},{"$f":"O11*(E85*P20*O9*Q17)","v":0},{"$f":"O11*(F85*P20*O9*R17)","v":0},{"$f":"O11*(G85*P20*O9*S17)","v":0},{"$f":"O11*(H85*P20*O9*T17)","v":0},{"$f":"O11*(I85*P20*O9*U17)","v":0},null,null,null,0,"",""]
[null,"Tubastraea diaphana",null,null,null,null,null,null,null,null,"Rare",null,null,null,{"$f":"O11*(C86*P20*Q9*O17)","v":0},{"$f":"O11*(D86*P20*Q9*P17)","v":0},{"$f":"O11*(E86*P20*Q9*Q17)","v":0},{"$f":"O11*(F86*P20*Q9*R17)","v":0},{"$f":"O11*(G86*P20*Q9*S17)","v":0},{"$f":"O11*(H86*P20*Q9*T17)","v":0},{"$f":"O11*(I86*P20*Q9*U17)","v":0},null,null,null,0,"",""]
[null,"Rhizopsammia verrilli",null,null,null,null,null,null,null,null,"Uncommon",null,null,null,{"$f":"O11*(C87*P20*P9*O17)","v":0},{"$f":"O11*(D87*P20*P9*P17)","v":0},{"$f":"O11*(E87*P20*P9*Q17)","v":0},{"$f":"O11*(F87*P20*P9*R17)","v":0},{"$f":"O11*(G87*P20*P9*S17)","v":0},{"$f":"O11*(H87*P20*P9*T17)","v":0},{"$f":"O11*(I87*P20*P9*U17)","v":0},null,null,null,{"$f":"SUM(C87:H87)","v":0},{"$f":"IF(Y87<>0,Y87/SUM(Y$22:Y$89),\"\")","v":""},{"$f":"IF(Z87<>\"\",Z87*(LN(Z87)),\"\")","v":""}]
[null,"Eguichipsammia serpentina",null,null,null,null,null,null,null,null,"Rare",null,null,null,{"$f":"O11*(C88*P20*Q9*O17)*S9","v":0},{"$f":"O11*(D88*P20*Q9*P17)*S9","v":0},{"$f":"O11*(E88*P20*Q9*Q17)*S9","v":0},{"$f":"O11*(F88*P20*Q9*R17)*S9","v":0},{"$f":"O11*(G88*P20*Q9*S17)*S9","v":0},{"$f":"O11*(H88*P20*Q9*T17)*S9","v":0},{"$f":"O11*(I88*P20*Q9*U17)*S9","v":0},null,null,null,{"$f":"SUM(C88:H88)","v":0},{"$f":"IF(Y88<>0,Y88/SUM(Y$22:Y$89),\"\")","v":""},{"$f":"IF(Z88<>\"\",Z88*(LN(Z88)),\"\")","v":""}]
[null,"Cladopsammia eguichii (Balonophyllia)",null,null,null,null,null,null,null,null,"Uncommon",null,null,null,{"$f":"O11*(C89*P20*P9*O17)","v":0},{"$f":"O11*(D89*P20*P9*P17)","v":0},{"$f":"O11*(E89*P20*P9*Q17)","v":0},{"$f":"O11*(F89*P20*P9*R17)","v":0},{"$f":"O11*(G89*P20*P9*S17)","v":0},{"$f":"O11*(H89*P20*P9*T17)","v":0},{"$f":"O11*(I89*P20*P9*U17)","v":0},null,null,null,{"$f":"SUM(C89:H89)","v":0},{"$f":"IF(Y89<>0,Y89/SUM(Y$22:Y$89),\"\")","v":""},{"$f":"IF(Z89<>\"\",Z89*(LN(Z89)),\"\")","v":""}]
[]
["Step 4","Results"]
[null,"Total Coral Colonies:",{"$f":"SUM(C20:C90)","v":0},{"$f":"SUM(D20:D90)","v":0},0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"# Species (N)=",{"$f":"COUNTIF(Y22:Y89,\">0\")","v":0},"SW Value:",{"$f":"SUM(AA22:AA89)","v":0}]
[null,null,null,null,null,null,null,"Total Colonies All Sizes:",{"$f":"SUM(C92:I92)","v":0}]
[null,"Functional Forms","Characterization Values",null,null,null,null,"Total Characterization Value",null,{"$f":"J136","v":0}]
[null,"BRANCHING (Example: Pocillopora spp =Poc) ","Total Characterization","Total Colonies"]
[null,"0-5 cm",{"$f":"O22+O23+O24+O25+O26+O54","v":0},{"$f":"C22+C23+C24+C25+C26+C54","v":0}]
[null,">5-10 cm",{"$f":"P22+P23+P24+P25+P26+P54","v":0},{"$f":"D22+D23+D24+D25+D26+D54","v":0}]
[null,">10-20 cm",{"$f":"Q22+Q23+Q24+Q25+Q26+Q54","v":0},{"$f":"E22+E23+E24+E25+E26+E54","v":0}]
[null,">20-40 cm",{"$f":"R22+R23+R24+R25+R26","v":0},{"$f":"F22+F23+F24+F25+F26","v":0}]
[null,">40-80 cm",{"$f":"S22+S23+S24+S25+S26","v":0},{"$f":"G22+G23+G24+G25+G26","v":0}]
[null,">80-160 cm",{"$f":"T22+T23+T24+T25+T26","v":0},{"$f":"H22+H23+H24+H25+H26","v":0},null,{"$f":"SUM(C96:C101)","v":0}]
[null,"> 160 cm",null,null,"Total BRANCHING",{"$f":"SUM(D96:D101)","v":0}]
[null,"ENCRUSTING (Example: Montipora spp. = MON)  "]
[null,"0-5 cm",{"$f":"O28+O29+O30+O32+O33+O38+O42+O51+O52+O53+O55+O56+O57+O60+O61+O64+O65+O66+O78+O79+O80+O81+O82+O83","v":0},{"$f":"C28+C29+C30+C32+C33+C38+C42+C51+C52+C53+C55+C56+C57+C60+C61+C64+C65+C66+C78+C79+C80+C81+C82+C83","v":0}]
[null,">5-10 cm",{"$f":"P28+P29+P30+P32+P33+P38+P42+P51+P52+P53+P55+P56+P57+P60+P61+P64+P65+P66+P78+P79+P80+P81+P82+P83","v":0},{"$f":"D28+D29+D30+D32+D33+D38+D42+D51+D52+D53+D55+D56+D57+D60+D61+D64+D65+D66+D78+D79+D80+D81+D82+D83","v":0}]
[null,">10-20 cm",{"$f":"Q28+Q29+Q30+Q32+Q33+Q38+Q42+Q51+Q52+Q53+Q55+Q56+Q57+Q60+Q61+Q64+Q65+Q66+Q78+Q79+Q80+Q81+Q82+Q83","v":0},{"$f":"E28+E29+E30+E32+E33+E38+E42+E51+E52+E53+E55+E56+E57+E60+E61+E64+E65+E67+E78+E79+E80+E81+E82+E83","v":0}]
[null,">20-40 cm",{"$f":"R30+R32+R33+R42+R51+R52+R53+R55+R56+R57+R60+R61+R64+R65+R66+R78+R79+R80+R81","v":0},{"$f":"F30+F32+F33+F42+F51+F52+F53+F55+F56+F57+F60+F61+F64+F65+F66+F78+F79+F80+F81","v":0}]
[null,">40-80 cm",{"$f":"S30+S32+S33+S42+S51+S52+S53+S55+S56+S57+S60+S61+S64+S65+S66+S78+S79+S80+S81","v":0},{"$f":"G30+G32+G33+G42+G52+G51+G53+G55+G56+G57+G60+G61+G64+G65+G66","v":0}]
[null,">80-160 cm",{"$f":"T30+T32+T33+T42+T51+T52+T53+T55+T56+T60+T61+T64+T65+T66+T78+T79+T81","v":0},{"$f":"H30+H32+H33+H42+H51+H52+H53+H55+H56+H57+H60+H61+H64+H65+H66+H78+H79+H81","v":0},null,{"$f":"SUM(C104:C110)","v":0}]
[null,"> 160 cm",{"$f":"U30+U32+U33+U42+U51+U52+U53+U55+U56+U60+U61+U64+U65+U66+U78+U79+U81","v":0},{"$f":"I30+I32+I33+I42+I51+I52+I53+I55+I56+I60+I61+I64+I65+I66+I78+I79+I9+I81","v":0},"Total ENCRUSTING",{"$f":"SUM(D104:D110)","v":0}]
[null,"MASSIVE (Example: Porites spp. = POR)"]
[null,"0-5 cm",{"$f":"O37+O39+O43+O44+O48+O49+O59+O70","v":0},{"$f":"C37+C39+C43+C44+C48+C49+C59+C70+C20","v":0}]
[null,">5-10 cm",{"$f":"P37+P39+P43+P48+P49+P59+P70","v":0},{"$f":"D20+D37+D39+D43+D44+D48+D49+D59+D70","v":0}]
[null,">10-20 cm",{"$f":"Q37+Q39+Q43+Q44+Q48+Q49+Q59+Q70","v":0},{"$f":"E20+E37+E39+E43+E44+E48+E49+E59+E70","v":0}]
[null,">20-40 cm",{"$f":"R37+R39+R43+R44+R48+R49+R59+R70","v":0},{"$f":"F37+F39+F43+F44+F48+F49+F59+F70","v":0}]
[null,">40-80 cm",{"$f":"S37+S39+S43+S44+S48+S49+S59+S70","v":0},{"$f":"G37+G39+G43+G44+G48+G49+G59+G70","v":0}]
[null,">80-160 cm",{"$f":"T37+T43+T44+T48+T59+T70","v":0},{"$f":"H37+H43+H44+H48+H59+H70","v":0},null,{"$f":"SUM(C112:C118)","v":0}]
[null,"> 160 cm",{"$f":"U37+U43+U44+U48+U59+U70","v":0},{"$f":"I37+I43+I44+I48+I59+I70","v":0},"Total MASSIVE",{"$f":"SUM(D112:D118)","v":0}]
[null,"PLATE-LIKE"]
[null,"0-5 cm",{"$f":"O45","v":0},{"$f":"C45","v":0}]
[null,">5-10 cm",{"$f":"P45","v":0},{"$f":"D45","v":0}]
[null,">10-20 cm",{"$f":"Q45","v":0},{"$f":"E45","v":0}]
[null,">20-40 cm",{"$f":"R28+R45","v":0},{"$f":"F28+F45","v":0}]
[null,">40-80 cm",{"$f":"S28+S45","v":0},{"$f":"G28+G45","v":0}]
[null,">80-160 cm",{"$f":"T28+T45","v":0},{"$f":"H28+H45","v":0},null,{"$f":"SUM(C120:C126)","v":0}]
[null,"> 160 cm",{"$f":"U28+U45","v":0},{"$f":"I28+I45","v":0},"Total PLATE",{"$f":"SUM(D120:D126)","v":0}]
[null,"FREE-LIVING (Example: Fungia spp. = FUN)"]
[null,"0-5 cm",{"$f":"O72+O73+O74+O75+O76","v":0},{"$f":"C72+C73+C74+C75+C76","v":0}]
[null,">5-10 cm",{"$f":"0+P72+P73+P74+P75+P76","v":0},{"$f":"D72+D73+D74+D75+D76","v":0}]
[null,">10-20 cm",{"$f":"Q72+Q73+Q74+Q75+Q76","v":0},{"$f":"E72+E73+E74+E75+E76","v":0}]
[null,">20-40 cm",{"$f":"R75+R76","v":0},{"$f":"F75+F76","v":0}]
[null,">40-80 cm",0,{"$f":"G75+G76","v":0}]
[null,">80-160 cm",null,null,null,{"$f":"SUM(C128:C132)","v":0}]
[null,"> 160 cm",null,null,"Total FREE",{"$f":"SUM(D128:D132)","v":0},null,null,null,"Total Characterization Value (All Colonies)"]
[null,"DIGIFORM (FINGER-LIKE) (Example: Porites compressa = PCO) "]
[null,"0-5 cm",{"$f":"O31+O40+O41+O46+O47","v":0},{"$f":"C31+C40+C41+C46+C47","v":0},null,null,null,null,null,{"$f":"F101+F109+F117+F125+F133+F141+F149+F157+F163","v":0}]
[null,">5-10 cm",{"$f":"P31+P40+P41+P46+P47","v":0},{"$f":"D31+D40+D41+D46+D47","v":0}]
[null,">10-20 cm",{"$f":"Q31+Q40+Q41","v":0},{"$f":"E31+E40+E41+E46+E47","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Percentage of each form by Ecological Services & Functional (ECV) Value"]
[null,">20-40 cm",{"$f":"R29+R31+R40+R41+R46+R47","v":0},{"$f":"F29+F31+F40+F41+F46+F47","v":0}]
[null,">40-80 cm",{"$f":"S29+S31+S40+S41+S46+S47","v":0},{"$f":"G29+G31+G40+G41+G46+G47","v":0}]
[null,">80-160 cm",{"$f":"T29+T31+T40+T41+T46+T47","v":0},{"$f":"H29+H31+H40+H41+H46+H47","v":0},null,{"$f":"SUM(C136:C142)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"BRANCHING",{"$f":"IF(F101/J94>0,F101/J94, \"  \")","v":{"$error":"#DIV/0!"}}]
[null,"> 160 cm",{"$f":"U29+U31+U40+U41+U46+U47","v":0},{"$f":"I29+I31+I40+I41+I46+I47","v":0},"Total FINGER",{"$f":"SUM(D136:D142)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ENCRUSTING",{"$f":"IF(F109/J94>0,F109/J94,\" \")","v":{"$error":"#DIV/0!"}}]
[null,"TABLE (Example:Acropora spp. = ACR)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MASSIVE",{"$f":"IF(F117/J94>0,F117/J94,\" \")","v":{"$error":"#DIV/0!"}}]
[null,"0-5 cm",0,{"$f":"C35","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PLATE-LIKE",{"$f":"IF(F125/J94>0,F125/J94,\" \")","v":{"$error":"#DIV/0!"}}]
[null,">5-10 cm",0,{"$f":"D35","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"FREE-LIVING",{"$f":"IF(F133/J94>0,F133/J94,\" \")","v":{"$error":"#DIV/0!"}}]
[null,">10-20 cm",0,{"$f":"E35","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"DIGIFORM",{"$f":"IF(F141/J94>0,F141/J94,\" \")","v":{"$error":"#DIV/0!"}}]
[null,">20-40 cm",0,{"$f":"F35","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TABLE",{"$f":"IF(F149/J94>0,F149/J94,\" \")","v":{"$error":"#DIV/0!"}}]
[null,">40-80 cm",0,{"$f":"G35","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SOLITARY",{"$f":"IF(F157/J94>0,F157/J94,\" \")","v":{"$error":"#DIV/0!"}}]
[null,">80-160 cm",0,{"$f":"H35","v":0},null,{"$f":"SUM(C144:C150)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"FOLIACEOUS",{"$f":"IF(F163/J94>0,F163/J94,\" \")","v":{"$error":"#DIV/0!"}}]
[null,"> 160 cm",0,{"$f":"I35","v":0},"Total TABLE",{"$f":"SUM(D144:D150)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(V141:V149)","v":{"$error":"#DIV/0!"}}]
[null,"SOLITARY (Example: Tubasatraea spp = TUB)"]
[null,"0-5 cm",{"$f":"0+O85+O86+O87+O88+O89","v":0},{"$f":"C85+C86+C87+C88+C89","v":0}]
[null,">5-10 cm",{"$f":"0+P85+P86+P87+P88+P89","v":0},{"$f":"D85+D86+D87+D88+D89","v":0}]
[null,">10-20 cm",{"$f":"0+Q85+Q86+Q87+Q88+Q89","v":0},{"$f":"E85+E86+E87+E88+E89","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Percentage of each size category by ECV Value"]
[null,">20-40 cm",{"$f":"0+R85+R86+R87+R88+R89","v":0},{"$f":"F85+F86+F87+F88+F89","v":0}]
[null,">40-80 cm",{"$f":"0+S85+S86+S87+S88+S89","v":0},{"$f":"G85+G86+G87+G88+G89","v":0}]
[null,">80-160 cm",{"$f":"0+T85+T86+T87+T88+T89","v":0},{"$f":"H85+H86+H87+H88+H89","v":0},null,{"$f":"SUM(C152:C158)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"0 - 5 cm",{"$f":"IF(C170/C177>0,C170/C177,\" \")","v":{"$error":"#DIV/0!"}}]
[null,"> 160 cm",{"$f":"0+U85+U86+U87+U88+U89","v":0},{"$f":"I85+I86+I87+I88+I89","v":0},"Total SOLITARY",{"$f":"SUM(D152:D158)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,">5 - 10 cm",{"$f":"IF(C171/C177>0,C171/C177,\" \")","v":{"$error":"#DIV/0!"}}]
[null,"FOLIACEUS (FLOWER-LIKE) (Example: Leptoseris papyracea = LEP)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,">10 - 20 cm",{"$f":"IF(C172/C177>0,C172/C177,\" \")","v":{"$error":"#DIV/0!"}}]
[null,"0-5 cm",{"$f":"O63+O67+O68+O69","v":0},{"$f":"C63+C67+C68+C69","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,">20 - 40 cm",{"$f":"IF(C173/C177>0,C173/C177,\" \")","v":{"$error":"#DIV/0!"}}]
[null,">5-10 cm",{"$f":"P63+P67+P68+P69","v":0},{"$f":"D63+D67+D68+D69","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,">40 - 80 cm",{"$f":"IF(C174/C177>0,C174/C177,\" \")","v":{"$error":"#DIV/0!"}}]
[null,">10-20 cm",{"$f":"Q63+Q67+Q68+Q69","v":0},{"$f":"E63+E67+E68+E69","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,">80 - 160 cm",{"$f":"IF(C175/C177>0,C175/C177,\" \")","v":{"$error":"#DIV/0!"}}]
[null,">20-40 cm",{"$f":"R63+R67+R68+R69","v":0},{"$f":"F63+F67+F68+F69","v":0},null,{"$f":"SUM(C160:C164)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"> 160 cm",{"$f":"IF(C176/C177>0,C176/C177,\" \")","v":{"$error":"#DIV/0!"}}]
[null,">40-80 cm",{"$f":"S63+S67+S68+S69","v":0},{"$f":"G63+G67+G68+G69","v":0},"Total FLOWER",{"$f":"SUM(D160:D164)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(V157:V163)","v":{"$error":"#DIV/0!"}}]
[null,">80-160 cm"]
[null,"> 160 cm"]
[]
[]
[null,"totals for all corals in each size class per site","Characterization Value","Total Number of Coral Colonies","Number of Colonies/m2","Number of Colonies/acre"]
[null,"0-5 cm",{"$f":"C96+C104+C112+C120+C128+C136+C144+C152+C160","v":0},{"$f":"C92","v":0},{"$f":"D170/K4","v":{"$error":"#DIV/0!"}},{"$f":"D170/H4","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Percentage of each form by colony numbers"]
[null,">5-10 cm",{"$f":"C97+C105+C113+C121+C129+C137+C145+C153+C161","v":0},{"$f":"D92","v":0},{"$f":"D171/K4","v":{"$error":"#DIV/0!"}},{"$f":"D171/H4","v":{"$error":"#DIV/0!"}}]
[null,">10-20 cm",{"$f":"C98+C106+C114+C122+C130+C138+C146+C154+C162","v":0},{"$f":"E92","v":0},{"$f":"D172/K4","v":{"$error":"#DIV/0!"}},{"$f":"D172/H4","v":{"$error":"#DIV/0!"}}]
[null,">20-40 cm",{"$f":"C99+C107+C115+C123+C131+C139+C147+C155+C163","v":0},{"$f":"F92","v":0},{"$f":"D173/K4","v":{"$error":"#DIV/0!"}},{"$f":"D173/H4","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"BRANCHING",{"$f":"IF(F102/I93>0,F102/I93,\" \")","v":{"$error":"#DIV/0!"}}]
[null,">40-80 cm",{"$f":"C100+C108+C116+C124+C132+C140+C148+C156+C164","v":0},{"$f":"G92","v":0},{"$f":"D174/K4","v":{"$error":"#DIV/0!"}},{"$f":"D174/H4","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ENCRUSTING",{"$f":"IF(F110/I93>0,F110/I93,\" \")","v":{"$error":"#DIV/0!"}}]
[null,">80-160 cm",{"$f":"C101+C109+C117+C125+C141+C149+C157","v":0},{"$f":"H92","v":0},{"$f":"D175/K4","v":{"$error":"#DIV/0!"}},{"$f":"D175/H4","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MASSIVE",{"$f":"IF(F118/I93>0,F118/I93,\" \")","v":{"$error":"#DIV/0!"}}]
[null,"> 160 cm",{"$f":"C110+C118+C126+C142+C150+C158","v":0},{"$f":"I92","v":0},{"$f":"D176/K4","v":{"$error":"#DIV/0!"}},{"$f":"D176/H4","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PLATE-LIKE",{"$f":"IF(F126/I93>0,F126/I93,\" \")","v":{"$error":"#DIV/0!"}}]
[null,"TOTAL",{"$f":"SUM(C170:C176)","v":0},{"$f":"SUM(D170:D176)","v":0},{"$f":"D177/K4","v":{"$error":"#DIV/0!"}},{"$f":"D177/H4","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"FREE-LIVING",{"$f":"IF(F134/I93>0,F134/I93,\" \")","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"DIGIFORM",{"$f":"IF(F142/I93>0,F142/I93,\" \")","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TABLE",{"$f":"IF(F150/I93>0,F150/I93,\" \")","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SOLITARY",{"$f":"IF(F158/I93>0,F158/I93,\" \")","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"FOLIACEOUS",{"$f":"IF(F164/I93>0,F164/I93,\" \")","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(V173:V181)","v":{"$error":"#DIV/0!"}}]
[null,"Total Colony Charecterization Value per m2",null,{"$f":"C177/K4","v":{"$error":"#DIV/0!"}}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Percentage of each size category by colony numbers"]
[null,"Total Colony Charecterization Value  per Acre",null,{"$f":"C177/H4","v":{"$error":"#DIV/0!"}}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"0 - 5 cm",{"$f":"IF(D170/D177>0,D170/D177,\" \")","v":{"$error":"#DIV/0!"}}]
[null,"Species Richness ( N/m2)",null,null,{"$f":"Y92/K4","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,">5 - 10 cm",{"$f":"IF(D171/D177>0,D171/D177,\" \")","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,">10 - 20 cm",{"$f":"IF(D172/D177>0,D172/D177,\" \")","v":{"$error":"#DIV/0!"}}]
[null,"Species Diversity: Shannon-Weaver Diversity Value (H'= - ∑(Ni/N) × ln (Ni/N)) - where low diversity approaches zero",null,null,{"$f":"AA92","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,">20 - 40 cm",{"$f":"IF(D173/D177>0,D173/D177,\" \")","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,">40 - 80 cm",{"$f":"IF(D174/D177>0,D174/D177,\" \")","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,">80 - 160 cm",{"$f":"IF(D175/D177>0,D175/D177,\" \")","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"> 160 cm",{"$f":"IF(D176/D177>0,D176/D177,\" \")","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(V188:V194)","v":{"$error":"#DIV/0!"}}]
[]
[]
[]
[null,"Created by Dave Gulko 2023, after State of Hawaii version created by D Gulko in 2016."]

{"sheet":"Sheet2","index":2,"n_rows":44,"n_cols":7,"rows_kept":44,"cut":false,"hidden":true,"merged":[]}
[]
[]
["Man-Made Structure",null,null,null,null,"Natural","Unconsolidated Substrate"]
["Previously Altered or Degraded"]
["Natural Habitat - Consolidated Colonies",null,null,null,null,"Altered","Ship Channel Walls"]
[]
[null,null,null,null,null,"ManMade"]
["Unconsolidated Substrate"]
["Boulder"]
["Solitary Colony"]
["Aggregated Colonies"]
["Reef Flat"]
["Reef Crest"]
["Reef Slope"]
["Patch Reef"]
["Spur and Groove"]
["Reef Hole","Size","Cost","Number"]
["Pinnacle Reef",{"$f":"'Coral Assessment '!B170","v":"0-5 cm"},{"$f":"'Coral Assessment '!#REF!","v":{"$error":"#REF!"}},{"$f":"'Coral Assessment '!D170","v":0}]
["Deep Reef",{"$f":"'Coral Assessment '!B171","v":">5-10 cm"},{"$f":"'Coral Assessment '!#REF!","v":{"$error":"#REF!"}},{"$f":"'Coral Assessment '!D171","v":0}]
[null,{"$f":"'Coral Assessment '!B172","v":">10-20 cm"},{"$f":"'Coral Assessment '!#REF!","v":{"$error":"#REF!"}},{"$f":"'Coral Assessment '!D172","v":0}]
[null,{"$f":"'Coral Assessment '!B173","v":">20-40 cm"},{"$f":"'Coral Assessment '!#REF!","v":{"$error":"#REF!"}},{"$f":"'Coral Assessment '!D173","v":0}]
[null,{"$f":"'Coral Assessment '!B174","v":">40-80 cm"},{"$f":"'Coral Assessment '!#REF!","v":{"$error":"#REF!"}},{"$f":"'Coral Assessment '!D174","v":0}]
["Damaged Area (Unplanned Event)",{"$f":"'Coral Assessment '!B175","v":">80-160 cm"},{"$f":"'Coral Assessment '!#REF!","v":{"$error":"#REF!"}},{"$f":"'Coral Assessment '!D175","v":0}]
["Area to be Impacted (Planned Event)",{"$f":"'Coral Assessment '!B176","v":"> 160 cm"},{"$f":"'Coral Assessment '!#REF!","v":{"$error":"#REF!"}},{"$f":"'Coral Assessment '!D176","v":0}]
["Compensatory Mitigation Project Area"]
["On-Site Restoration Project Area"]
["Off-Site Restoration Project Area"]
[]
[]
["Artificial Reef"]
["Pile or Column"]
["Breakwater"]
["Submerged Wall"]
["Pipeline or Support Structure"]
["Mooring Block"]
["Submerged Debris"]
["Other"]
[]
["Ship Channel Walls"]
["Ship Channel Bottom"]
["Old Grounding Scar or Anchorage"]
["Natural Modified Harbor Walls"]
["Longterm Outfall or Dump Site"]
["Dominated by Invasive Species"]

{"sheet":"Sheet3","index":3,"n_rows":56,"n_cols":19,"rows_kept":56,"cut":false,"hidden":true,"merged":[[2,12,2,16]]}
[null,"0 - 5 cm",">5 - 10 cm",">10 - 20 cm",">20 - 40 cm",">40 - 80 cm",">80 - 160 cm",">160 cm "]
["BRANCHING",{"$f":"'Coral Assessment '!C96","v":0},{"$f":"'Coral Assessment '!C97","v":0},{"$f":"'Coral Assessment '!C98","v":0},{"$f":"'Coral Assessment '!C99","v":0},{"$f":"'Coral Assessment '!C100","v":0},{"$f":"'Coral Assessment '!C101","v":0}]
["ENCRUSTING",{"$f":"'Coral Assessment '!C104","v":0},{"$f":"'Coral Assessment '!C105","v":0},{"$f":"'Coral Assessment '!C106","v":0},{"$f":"'Coral Assessment '!C107","v":0},{"$f":"'Coral Assessment '!C108","v":0},{"$f":"'Coral Assessment '!C109","v":0},{"$f":"'Coral Assessment '!C110","v":0},null,null,null,null,"Coral Assessment B"]
["MASSIVE",{"$f":"'Coral Assessment '!C112","v":0},{"$f":"'Coral Assessment '!C113","v":0},{"$f":"'Coral Assessment '!C114","v":0},{"$f":"'Coral Assessment '!C115","v":0},{"$f":"'Coral Assessment '!C116","v":0},{"$f":"'Coral Assessment '!C117","v":0},{"$f":"'Coral Assessment '!C118","v":0},null,null,null,null,"0 - 5 cm",">5 - 10 cm",">10 - 20 cm",">20 - 40 cm",">40 - 80 cm",">80 - 160 cm",">160 cm "]
["PLATE-LIKE",{"$f":"'Coral Assessment '!C120","v":0},{"$f":"'Coral Assessment '!C121","v":0},{"$f":"'Coral Assessment '!C122","v":0},{"$f":"'Coral Assessment '!C123","v":0},{"$f":"'Coral Assessment '!C124","v":0},{"$f":"'Coral Assessment '!C125","v":0},{"$f":"'Coral Assessment '!C126","v":0},null,null,null,"BRANCHING",{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}}]
["FREE-LIVING",{"$f":"'Coral Assessment '!C128","v":0},{"$f":"'Coral Assessment '!C129","v":0},{"$f":"'Coral Assessment '!C130","v":0},{"$f":"'Coral Assessment '!C131","v":0},{"$f":"'Coral Assessment '!C132","v":0},null,null,null,null,null,"ENCRUSTING",{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}}]
["DIGIFORM",{"$f":"'Coral Assessment '!C136","v":0},{"$f":"'Coral Assessment '!C137","v":0},{"$f":"'Coral Assessment '!C138","v":0},{"$f":"'Coral Assessment '!C139","v":0},{"$f":"'Coral Assessment '!C140","v":0},{"$f":"'Coral Assessment '!C141","v":0},{"$f":"'Coral Assessment '!C142","v":0},null,null,null,"MASSIVE",{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}}]
["TABLE",{"$f":"'Coral Assessment '!C144","v":0},{"$f":"'Coral Assessment '!C145","v":0},{"$f":"'Coral Assessment '!C146","v":0},{"$f":"'Coral Assessment '!C147","v":0},{"$f":"'Coral Assessment '!C148","v":0},{"$f":"'Coral Assessment '!C149","v":0},{"$f":"'Coral Assessment '!C150","v":0},null,null,"Char","PLATE-LIKE",{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}}]
["SOLITARY",{"$f":"'Coral Assessment '!C152","v":0},{"$f":"'Coral Assessment '!C153","v":0},{"$f":"'Coral Assessment '!C154","v":0},{"$f":"'Coral Assessment '!C155","v":0},{"$f":"'Coral Assessment '!C156","v":0},{"$f":"'Coral Assessment '!C157","v":0},{"$f":"'Coral Assessment '!C158","v":0},null,null,null,"FREE-LIVING",{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}}]
["FOLIACEOUS",{"$f":"'Coral Assessment '!C160","v":0},{"$f":"'Coral Assessment '!C161","v":0},{"$f":"'Coral Assessment '!C162","v":0},{"$f":"'Coral Assessment '!C163","v":0},{"$f":"'Coral Assessment '!C164","v":0},null,null,null,null,null,"DIGIFORM",{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,"TABLE",{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,"0 - 5 cm",">5 - 10 cm",">10 - 20 cm",">20 - 40 cm",">40 - 80 cm",">80 - 160 cm",">160 cm ",null,null,null,"SOLITARY",{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}}]
["BRANCHING",{"$f":"'Coral Assessment '!D96","v":0},{"$f":"'Coral Assessment '!D97","v":0},{"$f":"'Coral Assessment '!D98","v":0},{"$f":"'Coral Assessment '!D99","v":0},{"$f":"'Coral Assessment '!D100","v":0},{"$f":"'Coral Assessment '!D101","v":0},null,null,null,null,"FOLIACEOUS",{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}}]
["ENCRUSTING",{"$f":"'Coral Assessment '!D104","v":0},{"$f":"'Coral Assessment '!D105","v":0},{"$f":"'Coral Assessment '!D106","v":0},{"$f":"'Coral Assessment '!D107","v":0},{"$f":"'Coral Assessment '!D108","v":0},{"$f":"'Coral Assessment '!D109","v":0},{"$f":"'Coral Assessment '!D110","v":0}]
["MASSIVE",{"$f":"'Coral Assessment '!D112","v":0},{"$f":"'Coral Assessment '!D113","v":0},{"$f":"'Coral Assessment '!D114","v":0},{"$f":"'Coral Assessment '!D115","v":0},{"$f":"'Coral Assessment '!D116","v":0},{"$f":"'Coral Assessment '!D117","v":0},{"$f":"'Coral Assessment '!D118","v":0},null,null,null,null,"0 - 5 cm",">5 - 10 cm",">10 - 20 cm",">20 - 40 cm",">40 - 80 cm",">80 - 160 cm",">160 cm "]
["PLATE-LIKE",{"$f":"'Coral Assessment '!D120","v":0},{"$f":"'Coral Assessment '!D121","v":0},{"$f":"'Coral Assessment '!D122","v":0},{"$f":"'Coral Assessment '!D123","v":0},{"$f":"'Coral Assessment '!D124","v":0},{"$f":"'Coral Assessment '!D125","v":0},{"$f":"'Coral Assessment '!D126","v":0},null,null,null,"BRANCHING",{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}}]
["FREE-LIVING",{"$f":"'Coral Assessment '!D128","v":0},{"$f":"'Coral Assessment '!D129","v":0},{"$f":"'Coral Assessment '!D130","v":0},{"$f":"'Coral Assessment '!D131","v":0},{"$f":"'Coral Assessment '!D132","v":0},null,null,null,null,"Colonies","ENCRUSTING",{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}}]
["DIGIFORM",{"$f":"'Coral Assessment '!D136","v":0},{"$f":"'Coral Assessment '!D137","v":0},{"$f":"'Coral Assessment '!D138","v":0},{"$f":"'Coral Assessment '!D139","v":0},{"$f":"'Coral Assessment '!D140","v":0},{"$f":"'Coral Assessment '!D141","v":0},{"$f":"'Coral Assessment '!D142","v":0},null,null,null,"MASSIVE",{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}}]
["TABLE",{"$f":"'Coral Assessment '!D144","v":0},{"$f":"'Coral Assessment '!D145","v":0},{"$f":"'Coral Assessment '!D146","v":0},{"$f":"'Coral Assessment '!D147","v":0},{"$f":"'Coral Assessment '!D148","v":0},{"$f":"'Coral Assessment '!D149","v":0},{"$f":"'Coral Assessment '!D150","v":0},null,null,null,"PLATE-LIKE",{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}}]
["SOLITARY",{"$f":"'Coral Assessment '!D152","v":0},{"$f":"'Coral Assessment '!D153","v":0},{"$f":"'Coral Assessment '!D154","v":0},{"$f":"'Coral Assessment '!D155","v":0},{"$f":"'Coral Assessment '!D156","v":0},{"$f":"'Coral Assessment '!D157","v":0},{"$f":"'Coral Assessment '!D158","v":0},null,null,null,"FREE-LIVING",{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}}]
["FOLIACEOUS",{"$f":"'Coral Assessment '!D160","v":0},{"$f":"'Coral Assessment '!D161","v":0},{"$f":"'Coral Assessment '!D162","v":0},{"$f":"'Coral Assessment '!D163","v":0},{"$f":"'Coral Assessment '!D164","v":0},null,null,null,null,null,"DIGIFORM",{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,"TABLE",{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,"SOLITARY",{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,"FOLIACEOUS",{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}}]
[]
[]
[]
[]
[]
["Artificial Reef",1,"Manmade",{"$f":"IF('Coral Assessment '!C12=\"Artificial Reef\",1,IF('Coral Assessment '!C12=\"Pile or Column\",0.5,IF('Coral Assessment '!C12=\"Breakwater\",0.5,IF('Coral Assessment '!C12=\"Submerged Wall\",0.5,0))))","v":0}]
["Pile or Column",0.5,"Manmade",{"$f":"IF('Coral Assessment '!C12=\"Pipeline or Support Structure\",1,IF('Coral Assessment '!C12=\"Mooring Block\",0.5,IF('Coral Assessment '!C12=\"Submerged Debris\",0.5,IF('Coral Assessment '!C12=\"Other\",1,0))))","v":0}]
["Breakwater",0.5,"Modified",{"$f":"IF('Coral Assessment '!C13=\"Ship Channel Walls\",0.5,IF('Coral Assessment '!C13=\"Ship Channel Bottom\",0.5,IF('Coral Assessment '!C13=\"Old Grounding Scar or Anchorage\",0.5,IF('Coral Assessment '!C13=\"Natural Modified Harbor Walls\",1,0))))","v":0}]
["Submerged Wall",0.5,"Modified",{"$f":"IF('Coral Assessment '!C13=\"Longterm Outfall or Dump Site\",1,IF('Coral Assessment '!C13=\"Dominated by Invasive Species\",0.5,0))","v":0}]
["Pipeline or Support Structure",1,"Natural",{"$f":"IF('Coral Assessment '!C14=\"Unconsolidated Substrate\",0.5,IF('Coral Assessment '!C14=\"Boulder\",3,IF('Coral Assessment '!C14=\"Solitary Colony\",2,IF('Coral Assessment '!C14=\"Aggregated Colonies\",3,0))))","v":0}]
["Mooring Block",0.5,"Natural",{"$f":"IF('Coral Assessment '!C14=\"Reef Flat\",4,IF('Coral Assessment '!C14=\"Reef Crest\",5,IF('Coral Assessment '!C14=\"Reef Slope\",5,IF('Coral Assessment '!C14=\"Patch Reef\",4,0))))","v":0}]
["Submerged Debris",0.5,"Natural",{"$f":"IF('Coral Assessment '!C14=\"Spur and Groove\",5,IF('Coral Assessment '!C14=\"Reef Hole\",4,IF('Coral Assessment '!C14=\"Pinnacle Reef\",4,IF('Coral Assessment '!C14=\"Deep Reef\",3,0))))","v":0}]
["Other",1,"Sum",{"$f":"SUM(D30:D36)","v":0}]
["Ship Channel Walls",0.5]
["Ship Channel Bottom",0.5]
["Grounding Scar or Anchorage",0.5]
["Natural Modified Harbor Walls",1]
["Longterm Outfall or Dump Site",1]
["Dominated by Invasive Species",0.5]
["Unconsolidated Substrate",0.5]
["Boulder",3]
["Solitary Colony",2]
["Aggregated Colonies",3]
["Reef Flat",4]
["Reef Crest",5]
["Reef Slope",5]
["Patch Reef",4]
["Spur and Groove",5]
["Reef Hole",4]
["Pinnacle Reef",4]
["Deep Reef",3]
[null,1]

{"sheet":"Justifications","index":4,"n_rows":122,"n_cols":28,"rows_kept":122,"cut":false,"hidden":false,"merged":[[92,1,92,2],[4,14,4,15],[5,14,5,15],[6,14,6,15],[7,14,7,15],[8,14,8,15],[9,14,9,15],[4,1,4,2],[5,10,5,13],[12,14,12,15],[13,14,13,15],[64,1,64,2],[64,6,64,8],[10,14,10,15],[35,1,35,2],[35,12,35,13],[11,14,11,15],[18,14,18,15],[19,14,19,15],[14,14,14,15],[15,14,15,15],[20,14,20,15],[21,14,21,15],[22,14,22,15],[23,14,23,15],[16,14,16,15],[17,14,17,15],[91,10,91,15],[4,16,4,22],[5,16,5,22],[6,16,6,22],[7,16,7,22],[8,16,8,22],[9,16,9,22],[10,16,10,22],[11,16,11,22],[12,16,12,22],[18,16,18,22],[13,16,13,22],[14,16,14,22],[15,16,15,22],[16,16,16,22],[17,16,17,22],[121,2,121,6],[21,16,21,22],[22,16,22,22],[23,16,23,22],[19,16,19,22],[20,16,20,22],[118,7,118,12],[87,8,87,12],[62,8,62,12],[24,16,24,22],[25,16,25,22],[91,16,91,27],[67,9,75,11],[65,9,65,10],[90,8,90,11],[91,3,91,9]]}
[]
[]
[]
[]
[null,"Size Services & Functions"]
[null,null,null,"0 - 5 cm",">5 - 10 cm",">10 - 20 cm",">20 - 40 cm",">40 cm - 80 cm",">80 - 160 cm",">160 cm","Assumes same species and form for each size."]
[null,"Regulatory Function","Sand Formation",0,0,1,2,8,32,160]
[null,null,"Gas Production",0,1,2,4,12,48,192]
[null,null,"Climate Regulation",0,0,1,3,12,48,192]
[null,null,"Wave Energy Regulation",0,0,1,3,12,48,192]
[null,null,"Nutrient/Carbon Cycling",0,1,2,4,12,48,192]
[null,"Habitat Functions","Ecological/Symbiotic Interactions",0,1,2,4,12,48,240]
[null,null,"Cleaning Stations",0,0,0,2,8,24,100]
[null,null,"Shelter Refuge for flora/fauna (I.e. multiple fish/invertebrates/sea turtles, etc.)",0,1,2,3,12,36,180]
[null,null,"Reproductive Habitat For Fauna",0,0,1,2,10,40,160]
[null,null,"Foraging Habitat for Natural Assemblages",0,1,2,5,15,60,300]
[null,null,"Nursery Functions",0,0,1,3,15,60,300]
[null,"Production Services","Food from System Inhabitants",0,0,1,3,12,60,360]
[null,null,"Medicinal Resources",0.5,1,2,3,10,20,30]
[null,null,"Ornamental Resources",0,1,2,5,20,100,500]
[null,"Information Services","Aesthetics",0,1,2,5,20,100,500]
[null,null,"Recreation",0,0,2,5,10,15,20]
[null,null,"Cultural Value (Fishing Koas, etc.)",0,0,1,3,5,15,45]
[null,null,"Spiritual Value",0,1,1,2,2,5,5]
[null,null,"Historical Record",0,0,1,2,10,40,300]
[null,null,"Educatonal Value",1,1,2,3,12,48,240]
[null,null,"Research Value",1,1,2,3,6,15,75]
[null,null,"Other",1,1,1,1,1,1,1]
[null,"Temporal Loss"," (Assumes avg growth of 2 cm/yr)",0,1,5,10,50,200,1200]
[]
[null,null,"Sum",{"$f":"SUM(D7:D29)","v":3.5},13,37,80,{"$f":"SUM(H7:H29)","v":286},{"$f":"SUM(I7:I29)","v":1111},{"$f":"SUM(J7:J29)","v":5484}]
[null,null,"Scoring for Assessment",0.25,0.5,2,5,20,100,500]
[]
[]
[]
[null,"Colony Form Services & Functions",null,"Encrusting","Massive","Branching","Digiform","Foliaceous","Free-Living","Solitary","Plate","Table","Assumes same size colony (lg) of each form"]
[null,"Regulatory Function","Sand Formation",1,5,4,4,4,1,1,3,4]
[null,null,"Gas Production",2,3,4,4,4,2,1,2,3]
[null,null,"Climate Regulation",2,2,2,2,2,2,2,2,2]
[null,null,"Wave Energy Regulation",1,5,3,3,3,1,1,2,3]
[null,null,"Nutrient/Carbon Cycling",2,3,3,3,3,2,2,2,3]
[null,"Habitat Functions","Ecological/Symbiotic Interactions",1,5,5,4,4,2,1,3,5]
[null,null,"Cleaning Stations",0,5,3,4,3,0,0,2,3]
[null,null,"Shelter Refuge for flora/fauna (I.e. multiple fish/invertebrates/sea turtles, etc.)",0,5,4,3,3,1,1,3,5]
[null,null,"Reproductive Habitat For Fauna",0,5,4,4,4,1,1,4,5]
[null,null,"Foraging Habitat for Natural Assemblages",1,5,4,3,3,1,1,3,5]
[null,null,"Nursery Functions",0,4,5,4,3,1,1,3,5]
[null,"Production Services","Food from System Inhabitants",0,5,3,3,3,0,0,3,4]
[null,null,"Medicinal Resources",2,2,2,2,2,2,2,2,2]
[null,null,"Ornamental Resources",1,4,5,4,4,1,1,4,4]
[null,"Information Services","Aesthetics",1,5,5,4,4,2,2,4,5]
[null,null,"Recreation",1,5,4,4,5,1,1,4,5]
[null,null,"Cultural Value (Fishing Koas, etc.)",0,5,2,3,4,1,0,3,5]
[null,null,"Spiritual Value",2,2,2,2,2,2,2,2,2]
[null,null,"Historical Record",0,5,2,4,3,1,1,2,3]
[null,null,"Educatonal Value",2,2,2,2,2,2,2,2,2]
[null,null,"Research Value",3,3,3,3,3,3,3,3,3]
[null,null,"Other",2,2,2,2,2,2,2,2,2]
[]
[null,null,"Sum",24,87,73,71,70,31,28,60,80]
[null,null,"Scoring for Assessment",1,5,4,4,4,1,1,3,5]
[]
[null,null,null,null,null,null,null,"Score Range:"," < 20 = 0.5; 20 - <35 = 1; 35 - <50 = 2; 50 - <65 = 3; 65 - 79 = 4; 80+ = 5"]
[]
[null,"Rarity of Species",null,"Common","Uncommon","Rare","Assumes same colony size and form"]
[null,"Regulatory Function","Sand Formation",1,1,1,null,null,null,"Endemism"]
[null,null,"Gas Production",1,1,1]
[null,null,"Climate Regulation",1,1,1,null,null,null,"Because endemic species have no replacement pool, and often have co-evolved with other endemic species, creating unique ecological and symbiotic associations, such that impacts can have broader and more intense ecological effects.  Result is that we double the score for endemic species."]
[null,null,"Wave Energy Regulation",1,1,1]
[null,null,"Nutrient/Carbon Cycling",1,1,1]
[null,"Habitat Functions","Ecological/Symbiotic Interactions",1,1,1]
[null,null,"Cleaning Stations",1,1,1]
[null,null,"Shelter Refuge for flora/fauna (I.e. multiple fish/invertebrates/sea turtles, etc.)",1,1,1]
[null,null,"Reproductive Habitat For Fauna",1,1,1]
[null,null,"Foraging Habitat for Natural Assemblages",1,1,1]
[null,null,"Nursery Functions",1,1,1]
[null,"Production Services","Food from System Inhabitants",1,1,1]
[null,null,"Medicinal Resources",1,2,3]
[null,null,"Ornamental Resources",1,1,1]
[null,"Information Services","Aesthetics",1,2,3]
[null,null,"Recreation",1,1,1]
[null,null,"Cultural Value (Fishing Koas, etc.)",1,1,1]
[null,null,"Spiritual Value",1,1,1]
[null,null,"Historical Record",1,1,1]
[null,null,"Educatonal Value",1,2,3]
[null,null,"Research Value",1,2,3]
[null,null,"Other",1,1,1]
[null,null,null,null,null,null,null,"Score Range:"," < 25 = 1; 25 - <30 = 2; 30+ = 3"]
[null,null,"Sum",22,26,30]
[null,null,"Scoring for Assessment",1,2,3]
[null,null,null,null,null,null,null,null,"Assumes same species, colony size and form"]
[null,null,null,"Man-Made Structures",null,null,null,null,null,null,"Altered (by Man) Habitat",null,null,null,null,null,"Natural Habitat"]
[null,"Habitat Services & Functions",null,"Artificial Reef","Pile or Column","Breakwater","Submerged Wall","Pipeline or Support Structure","Mooring Block","Submerged Debris","Ship Channel Walls","Ship Channel Bottom","Grounding Scar or Anchorage","Natural Modified Harbor Walls","Longterm Outfall or Dump Site","Dominated by Invasive Species","Unconsolidated Substrate","Boulder","Solitary Colony","Aggregated Colonies","Reef Flat","Reef Crest","Reef Slope","Patch Reef","Spur and Groove","Reef Hole","Pinnacle Reef","Deep Reef"]
[null,"Regulatory Function","Sand Formation",0,0,3,0,2,1,1,2,1,3,0,3,2,2,3,2,3,4,5,4,2,5,4,2,0]
[null,null,"Gas Production",2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2]
[null,null,"Climate Regulation",2,2,2,2,2,2,2,3,3,3,3,3,3,3,2,3,4,4,4,4,4,4,4,4,4]
[null,null,"Wave Energy Regulation",0,0,3,0,2,1,1,2,0,3,0,3,3,2,5,2,3,4,5,4,2,5,2,2,0]
[null,null,"Nutrient/Carbon Cycling",2,2,2,2,2,2,2,2,2,2,2,2,1,2,2,2,3,4,4,4,4,4,4,4,4]
[null,"Habitat Functions","Ecological/Symbiotic Interactions",2,2,2,2,2,2,2,2,1,2,2,2,1,2,2,2,3,4,4,4,4,4,4,4,4]
[null,null,"Cleaning Stations",1,1,1,2,3,3,3,2,0,1,2,1,1,0,4,2,3,3,3,5,5,5,4,5,3]
[null,null,"Shelter Refuge for flora/fauna (I.e. multiple fish/invertebrates/sea turtles, etc.)",3,2,2,2,3,2,2,2,1,1,3,1,1,1,4,2,3,4,4,5,5,5,5,5,5]
[null,null,"Reproductive Habitat For Fauna",2,2,2,2,2,2,2,3,1,2,3,3,1,1,3,3,3,3,3,3,3,4,4,3,3]
[null,null,"Foraging Habitat for Natural Assemblages",2,2,2,2,2,2,2,3,2,2,3,2,1,2,2,2,3,4,4,4,4,4,4,4,4]
[null,null,"Nursery Functions",4,3,2,2,2,2,2,2,1,1,3,2,2,1,3,2,3,4,4,4,4,4,4,4,4]
[null,"Production Services","Food from System Inhabitants",5,2,1,1,3,1,2,2,1,1,2,2,1,1,3,2,3,4,4,4,3,4,4,4,3]
[null,null,"Medicinal Resources",2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2]
[null,null,"Ornamental Resources",2,2,1,2,2,2,2,1,1,1,2,1,1,1,3,2,3,4,4,4,4,4,4,4,4]
[null,"Information Services","Aesthetics",3,0,0,0,1,0,0,0,0,0,1,0,0,0,4,3,4,5,5,5,5,5,5,5,5]
[null,null,"Recreation",4,2,2,1,2,1,1,0,0,1,0,1,1,1,2,3,4,5,5,5,5,5,5,5,5]
[null,null,"Cultural Value (Fishing Koas, etc.)",0,0,0,0,0,0,0,0,0,1,1,1,1,1,2,3,3,3,3,3,3,3,2,3,0]
[null,null,"Spiritual Value",0,0,0,0,0,0,0,0,0,1,1,1,1,1,2,2,2,2,2,2,2,2,2,2,2]
[null,null,"Historical Record",0,0,0,1,1,0,1,1,1,1,2,0,1,0,2,3,4,4,4,4,4,4,3,4,4]
[null,null,"Educatonal Value",3,1,1,1,1,1,1,1,0,1,1,1,2,0,1,1,2,2,2,2,2,2,2,2,2]
[null,null,"Research Value",2,1,2,2,2,2,2,1,1,1,2,2,2,1,2,2,3,3,3,3,3,3,3,3,3]
[null,null,"Other",1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1]
[null,null,"Sum",42,29,33,29,39,31,33,34,21,33,38,36,31,27,56,48,64,75,77,78,73,81,74,74,64]
[null,null,"Scoring for Assessment",1,0.5,0.5,0.5,1,0.5,0.5,0.5,0.5,0.5,1,1,0.5,0.5,3,2,3,4,5,5,4,5,4,4,3]
[]
[null,null,null,null,null,null,"Score Range:"," < 35 = 0.5; 35 - 45 = 1; 45 - 55 = 2; 55 - 65 = 3; 65 - 75 = 4; >75 = 5"]
[]
[]
[null,null,"Created by Dave Gulko (2023), after State of Hawaii version created by D Gulko (2016)."]

{"sheet":"Definitions","index":5,"n_rows":42,"n_cols":3,"rows_kept":42,"cut":false,"hidden":false,"merged":[[41,1,41,2]]}
[]
[null,"Aggregated Colonies","A mixture of coral colonies in a dense cluster but NOT constitutuing a reef structure (I.e. having a identified reef flat, reef crest and reef slope)"]
[null,"Anchorage","A site for anchoring vessels or where anchoring has occurred."]
[null,"Artificial Reef","An artificial reef is a human-made underwater structure, typically built for the purpose of promoting marine life in areas of generally featureless bottom."]
[null,"Boulder","A boulder is a volcanic rock with grain size of no less than 256 mm (10 inches) diameter."]
[null,"Breakwater","Breakwaters are structures constructed on coasts as part of coastal defence or to protect an anchorage from the effects of weather, onshore waves, and longshore drift."]
[null,"Compensatory Mitigation","The restoration (re-establishment or rehabilitation), establishment (creation), enhancement, and/or in certain circumstances preservation of aquatic resources for the purposes of offsetting unavoidable, adverse impacts, which remain after all appropriate and practicable avoidance and minimization has been achieved."]
[null,"Coral Reef","A geographic structure consisting of a reef crest, a reef slope, and a reef flat."]
[null,"Damaged Area","The defined and measured area exposed to direct (Primary) and indirect (Secondary) impact from a planned or unplanned event."]
[null,"Deep Reef","A coral reef habitat below the depth of normal wave activity (I.e. deeper than 60 feet (~20 m))."]
[null,"Dump Site","Aquatic site used for solid waste, refuse or derelict material disposal."]
[null,"Endemic","Species that are only found (native) in a defined region, in this case, the Hawaiian Islands."]
[null,"Grounding Scar","The direct benthic substrate damage caused by the hull impact when a vessel runs aground."]
[null,"Habitat","A kind of aquatic site or region with respect to physical features naturally preferred by a system of aquatic organisms (example: sand, coral, algal, seagrass)."]
[null,"Invasive Species","Native or introduced aquatic species that threaten the biodiversity of an area and/or disrupt by a dominant colonization of a particular habitat from loss of natural controls (i.e.: predators or herbivores)."]
[null,"Longterm Outfall","The discharge point of a waste stream into nearshore waters that has been stationary for an extended (greater than 3 years) period of time."]
[null,"Man-Made Substrate","Sunmerged bottom habitat made of non-natural materials such as concrete, steel, etc."]
[null,"Mooring Block","A heavy block of cast iron, concrete or other materials that has been placed onto the bottom substrate and used as an anchor for mooring vessels."]
[null,"Natural Modified Harbor Walls","Inner walls of a marina or habror cut or modified out of the existing natural substrate (in Hawaii, usually basalt or fossilized coral)."]
[null,"On-Site Restoration","The return to a pre-impact state of the natural habitat and organisms at the site of impact."]
[null,"Patch Reef","A small, intact coral reef consisting of a reef slope on all sides of the reef and occurring within a lagoon or bay; in Hawaii often found within Kaneohe Bay."]
[null,"Pile or Column","Man-made, submerged verticle structure often used to support piers and wharfs to which coral colonies may be adhered."]
[null,"Pinnacle Reef","A defined reef structure with a reef crest and flat that is not within shallow water and not associated with a shoreline like fringing reefs."]
[null,"Pipeline","A long pipe used to transport oil, sewage, water, etc."]
[null,"Planned Event","A project causing impacts to aquatic habitat that is not accidental but is part of a targeted, planned project."]
[null,"Rarity","For corals, how uncommon a coral species is.  Rare coral species are those that might occur only once or twice along an average series of transects across different areas."]
[null,"Reef Crest","The region (in some places called an algal ridge) where the reef slope meets the reef flat is called the reef crest. This area is exposed to the highest wave energy. The crest has the best balance between sunlight and waves, so coral grow fastest here."]
[null,"Reef Flat","The reef flat is the shoreward, flat, broadest area of the reef. The reef flat is often found in fairly shallow water, and may be uncovered during low tide. This area of the reef is only slightly sloped towards the open ocean."]
[null,"Reef Hole","A depression, cave or enclosed space within a reef; usually with a diameter greater than 0.3 m."]
[null,"Reef Slope","The reef slope is found at the outer edge of the reef, closest to the open ocean. This area of the reef is often quite steep and may descend to either a sand/rubble bottom or to depths too great to allow coral growth."]
[null,"Ship Channel Bottom","In Hawaii, most marked ship channels occur in dredged shallow areas. The bottom of the channel refers to the roughly horizontal, center substrate areas of the channel and not the sides."]
[null,"Ship Channel Walls","In Hawaii, most marked ship channels occur in dredged shallow areas. The walls of the channel refer to the side steeply sloping or certical substrate areas of the channel and not the center."]
[null,"Solitary Colony","A coral colony that exists by itself on a bottom substrate and not pat of an aggregation or a coral reef."]
[null,"Spur & Grove","Finger-like, comb-tooth structures common to many coral reef fronts. Often best developed on the windward side of reefs, the structure consists of elongate channels or grooves, a few meters wide and deep, separated by seaward-extending coral ridges or spurs. Grooves are commonly floored with coral rubble or carbonate sand. Where actively accreting, spurs are covered with living corals. Where accretion has ceased, spurs harbor associated benthic organisms."]
[null,"Subhabitat","A defined phsyical subregion within a habitat (Example: Reef hole, Reef Slope, Reef Crest, etc.)."]
[null,"Submerged Debris","Man-made, derelict materials found underwater."]
[null,"Submerged Wall","Underwater man-made vertical structure (wall) usually composed of concrete or steel."]
[null,"Unconsolidated Substrate","Loose sediment of various grain sizes smaller than 256 mm (10 inches) diameter (example: mud, sand, etc.)."]
[null,"Unplanned Event","A project causing impacts to aquatic habitat that is accidental or negligent, not part of a targeted, planned project."]
[]
[]
[null,"Created by Dave Gulko (2023), after State of Hawai‘i version created by D Gulko (2016)."]

{"sheet":"CompFcnServ","index":6,"n_rows":65,"n_cols":27,"rows_kept":65,"cut":false,"hidden":false,"merged":[[7,1,7,7],[7,10,7,18],[7,21,7,23],[3,2,3,17],[64,1,64,7]]}
[]
[]
[]
[null,null,"Comparison of Ecological Functions and Services by Colony  Size, Colony Form, and Species Rarity"]
[]
[]
[]
[null,"Colony Size",null,null,null,null,null,null,null,null,"Colony Form",null,null,null,null,null,null,null,null,null,null,"Rarity",null,null,null,"Endemism"]
[null,"0 - 5 cm","5 - 10 cm","10 - 20 cm","20 - 40 cm","40 - 80 cm","80 - 160 cm","160+ cm",null,null,"Encrusting","Massive","Branching","Digiform","Foliaceous","Free-Living","Solitary","Plate","Table",null,null,"Common","Uncommon","Rare",null,"no","yes"]
["Regulatory Function",{"$f":"('Coral Assessment '!C92*SUM(Justifications!D7:D11))","v":0},{"$f":"('Coral Assessment '!D92*SUM(Justifications!E7:E11))","v":0},{"$f":"('Coral Assessment '!E92*SUM(Justifications!F7:F11))","v":0},{"$f":"('Coral Assessment '!F92*SUM(Justifications!G7:G11))","v":0},{"$f":"('Coral Assessment '!G92*SUM(Justifications!H7:H11))","v":0},{"$f":"('Coral Assessment '!H92*SUM(Justifications!I7:I11))","v":0},{"$f":"('Coral Assessment '!I92*SUM(Justifications!J7:J11))","v":0},null,"Regulatory Function",{"$f":"('Coral Assessment '!F110*SUM(Justifications!D37:D41))","v":0},{"$f":"('Coral Assessment '!F118*SUM(Justifications!E37:E41))","v":0},{"$f":"('Coral Assessment '!F102*SUM(Justifications!F37:F41))","v":0},{"$f":"('Coral Assessment '!F142*SUM(Justifications!G37:G41))","v":0},{"$f":"('Coral Assessment '!F164*SUM(Justifications!H37:H41))","v":0},{"$f":"('Coral Assessment '!F134*SUM(Justifications!I37:I41))","v":0},{"$f":"('Coral Assessment '!F158*SUM(Justifications!J37:J41))","v":0},{"$f":"('Coral Assessment '!F126*SUM(Justifications!K37:K41))","v":0},{"$f":"('Coral Assessment '!F150*SUM(Justifications!L37:L41))","v":0},null,"Regulatory Function",{"$f":"SUM('Coral Assessment '!C25+'Coral Assessment '!D25+'Coral Assessment '!E25+'Coral Assessment '!F25+'Coral Assessment '!G25+'Coral Assessment '!H25+'Coral Assessment '!C28+'Coral Assessment '!D28+'Coral Assessment '!E28+'Coral Assessment '!F28+'Coral Assessment '!G28+'Coral Assessment '!H28+'Coral Assessment '!I28+'Coral Assessment '!C30+'Coral Assessment '!D30+'Coral Assessment '!E30+'Coral Assessment '!F30+'Coral Assessment '!G30+'Coral Assessment '!H30+'Coral Assessment '!I30+'Coral Assessment '!C32+'Coral Assessment '!D32+'Coral Assessment '!E32+'Coral Assessment '!F32+'Coral Assessment '!G32+'Coral Assessment '!H32+'Coral Assessment '!I32+'Coral Assessment '!C40+'Coral Assessment '!D40+'Coral Assessment '!E40+'Coral Assessment '!F40+'Coral Assessment '!G40+'Coral Assessment '!H40+'Coral Assessment '!I40+'Coral Assessment '!C43+'Coral Assessment '!D43+'Coral Assessment '!E43+'Coral Assessment '!F43+'Coral Assessment '!G43+'Coral Assessment '!H43+'Coral Assessment '!I43+'Coral Assessment '!C61+'Coral Assessment '!D61+'Coral Assessment '!E61+'Coral Assessment '!F61+'Coral Assessment '!G61+'Coral Assessment '!H61+'Coral Assessment '!I61+'Coral Assessment '!C65+'Coral Assessment '!D65+'Coral Assessment '!E65+'Coral Assessment '!F65+'Coral Assessment '!G65+'Coral Assessment '!H65+'Coral Assessment '!I65+'Coral Assessment '!C69+'Coral Assessment '!D69+'Coral Assessment '!E69+'Coral Assessment '!F69+'Coral Assessment '!G69+'Coral Assessment '!C76+'Coral Assessment '!D76+'Coral Assessment '!E76+'Coral Assessment '!F76+'Coral Assessment '!G76+'Coral Assessment '!C83+'Coral Assessment '!D83+'Coral Assessment '!E83+'Coral Assessment '!C85+'Coral Assessment '!D85+'Coral Assessment '!E85+'Coral Assessment '!F85+'Coral Assessment '!G85+'Coral Assessment '!H85+'Coral Assessment '!I85)*SUM(Justifications!D66:D70)","v":0},{"$f":"SUM('Coral Assessment '!C22+'Coral Assessment '!D22+'Coral Assessment '!E22+'Coral Assessment '!F22+'Coral Assessment '!G22+'Coral Assessment '!H22+'Coral Assessment '!C23+'Coral Assessment '!D23+'Coral Assessment '!E23+'Coral Assessment '!F23+'Coral Assessment '!G23+'Coral Assessment '!H23+'Coral Assessment '!C31+'Coral Assessment '!D31+'Coral Assessment '!E31+'Coral Assessment '!F31+'Coral Assessment '!G31+'Coral Assessment '!H31+'Coral Assessment '!I31+'Coral Assessment '!C38+'Coral Assessment '!D38+'Coral Assessment '!E38+'Coral Assessment '!C39+'Coral Assessment '!D39+'Coral Assessment '!E39+'Coral Assessment '!F39+'Coral Assessment '!G39+'Coral Assessment '!C44+'Coral Assessment '!D44+'Coral Assessment '!E44+'Coral Assessment '!F44+'Coral Assessment '!G44+'Coral Assessment '!H44+'Coral Assessment '!I44+'Coral Assessment '!C45+'Coral Assessment '!D45+'Coral Assessment '!E45+'Coral Assessment '!F45+'Coral Assessment '!G45+'Coral Assessment '!H45+'Coral Assessment '!I45+'Coral Assessment '!C47+'Coral Assessment '!D47+'Coral Assessment '!E47+'Coral Assessment '!F47+'Coral Assessment '!G48+'Coral Assessment '!G47+'Coral Assessment '!H47+'Coral Assessment '!I47+'Coral Assessment '!I48+'Coral Assessment '!H48+'Coral Assessment '!F48+'Coral Assessment '!E48+'Coral Assessment '!D48+'Coral Assessment '!C48+'Coral Assessment '!C49+'Coral Assessment '!D49+'Coral Assessment '!E49+'Coral Assessment '!F49+'Coral Assessment '!G49+'Coral Assessment '!C53+'Coral Assessment '!D53+'Coral Assessment '!E53+'Coral Assessment '!F53+'Coral Assessment '!G53+'Coral Assessment '!H53+'Coral Assessment '!I53+'Coral Assessment '!C54+'Coral Assessment '!D54+'Coral Assessment '!E54+'Coral Assessment '!C59+'Coral Assessment '!D59+'Coral Assessment '!E59+'Coral Assessment '!F59+'Coral Assessment '!G59+'Coral Assessment '!H59+'Coral Assessment '!I59+'Coral Assessment '!C72+'Coral Assessment '!D72+'Coral Assessment '!E72+'Coral Assessment '!C75+'Coral Assessment '!D75+'Coral Assessment '!E75+'Coral Assessment '!F75+'Coral Assessment '!G75+'Coral Assessment '!C78+'Coral Assessment '!D78+'Coral Assessment '!E78+'Coral Assessment '!F78+'Coral Assessment '!G78+'Coral Assessment '!H78+'Coral Assessment '!I78+'Coral Assessment '!C80+'Coral Assessment '!D80+'Coral Assessment '!E80+'Coral Assessment '!F80+'Coral Assessment '!G80+'Coral Assessment '!C82+'Coral Assessment '!D82+'Coral Assessment '!E82+'Coral Assessment '!C87+'Coral Assessment '!D87+'Coral Assessment '!E87+'Coral Assessment '!F87+'Coral Assessment '!G87+'Coral Assessment '!H87+'Coral Assessment '!I87+'Coral Assessment '!C89+'Coral Assessment '!D89+'Coral Assessment '!E89+'Coral Assessment '!F89+'Coral Assessment '!G89+'Coral Assessment '!H89+'Coral Assessment '!I89)*SUM(Justifications!E66:E70)","v":0},{"$f":"SUM('Coral Assessment '!C20+'Coral Assessment '!D20+'Coral Assessment '!E20+'Coral Assessment '!C24+'Coral Assessment '!D24+'Coral Assessment '!E24+'Coral Assessment '!F24+'Coral Assessment '!G24+'Coral Assessment '!H24+'Coral Assessment '!C26+'Coral Assessment '!D26+'Coral Assessment '!E26+'Coral Assessment '!F26+'Coral Assessment '!G26+'Coral Assessment '!H26+'Coral Assessment '!C29+'Coral Assessment '!D29+'Coral Assessment '!E29+'Coral Assessment '!F29+'Coral Assessment '!G29+'Coral Assessment '!H29+'Coral Assessment '!I29+'Coral Assessment '!C33+'Coral Assessment '!D33+'Coral Assessment '!E33+'Coral Assessment '!F33+'Coral Assessment '!G33+'Coral Assessment '!H33+'Coral Assessment '!I33+'Coral Assessment '!C35+'Coral Assessment '!D35+'Coral Assessment '!E35+'Coral Assessment '!F35+'Coral Assessment '!G35+'Coral Assessment '!H35+'Coral Assessment '!I35+'Coral Assessment '!C37+'Coral Assessment '!D37+'Coral Assessment '!E37+'Coral Assessment '!F37+'Coral Assessment '!G37+'Coral Assessment '!H37+'Coral Assessment '!I37+'Coral Assessment '!C41+'Coral Assessment '!D41+'Coral Assessment '!E41+'Coral Assessment '!F41+'Coral Assessment '!G41+'Coral Assessment '!H41+'Coral Assessment '!I41+'Coral Assessment '!C42+'Coral Assessment '!D42+'Coral Assessment '!E42+'Coral Assessment '!F42+'Coral Assessment '!G42+'Coral Assessment '!H42+'Coral Assessment '!I42+'Coral Assessment '!C46+'Coral Assessment '!D46+'Coral Assessment '!E46+'Coral Assessment '!F46+'Coral Assessment '!G46+'Coral Assessment '!H46+'Coral Assessment '!I46+'Coral Assessment '!C51+'Coral Assessment '!D51+'Coral Assessment '!E51+'Coral Assessment '!F51+'Coral Assessment '!G51+'Coral Assessment '!H51+'Coral Assessment '!I51+'Coral Assessment '!C52+'Coral Assessment '!D52+'Coral Assessment '!E52+'Coral Assessment '!F52+'Coral Assessment '!G52+'Coral Assessment '!H52+'Coral Assessment '!I52+'Coral Assessment '!C55+'Coral Assessment '!D55+'Coral Assessment '!E55+'Coral Assessment '!F55+'Coral Assessment '!G55+'Coral Assessment '!H55+'Coral Assessment '!I55+'Coral Assessment '!C56+'Coral Assessment '!D56+'Coral Assessment '!E56+'Coral Assessment '!F56+'Coral Assessment '!G56+'Coral Assessment '!H56+'Coral Assessment '!I56+'Coral Assessment '!C57+'Coral Assessment '!D57+'Coral Assessment '!E57+'Coral Assessment '!F57+'Coral Assessment '!G57+'Coral Assessment '!C60+'Coral Assessment '!D60+'Coral Assessment '!E60+'Coral Assessment '!F60+'Coral Assessment '!G60+'Coral Assessment '!H60+'Coral Assessment '!I60+'Coral Assessment '!C63+'Coral Assessment '!D63+'Coral Assessment '!E63+'Coral Assessment '!F63+'Coral Assessment '!G63+'Coral Assessment '!C64+'Coral Assessment '!D64+'Coral Assessment '!E64+'Coral Assessment '!F64+'Coral Assessment '!G64+'Coral Assessment '!H64+'Coral Assessment '!I64+'Coral Assessment '!C66+'Coral Assessment '!D66+'Coral Assessment '!E66+'Coral Assessment '!F66+'Coral Assessment '!G66+'Coral Assessment '!H66+'Coral Assessment '!I66+'Coral Assessment '!C67+'Coral Assessment '!D67+'Coral Assessment '!E67+'Coral Assessment '!F67+'Coral Assessment '!I88+'Coral Assessment '!H88+'Coral Assessment '!G88+'Coral Assessment '!F88+'Coral Assessment '!E88+'Coral Assessment '!D88+'Coral Assessment '!C88+'Coral Assessment '!I86+'Coral Assessment '!H86+'Coral Assessment '!G86+'Coral Assessment '!F86+'Coral Assessment '!E86+'Coral Assessment '!D86+'Coral Assessment '!C86+'Coral Assessment '!I81+'Coral Assessment '!H81+'Coral Assessment '!G81+'Coral Assessment '!F81+'Coral Assessment '!E81+'Coral Assessment '!D81+'Coral Assessment '!C81+'Coral Assessment '!I79+'Coral Assessment '!H79+'Coral Assessment '!G79+'Coral Assessment '!F79+'Coral Assessment '!E79+'Coral Assessment '!D79+'Coral Assessment '!C79+'Coral Assessment '!E74+'Coral Assessment '!D74+'Coral Assessment '!C74+'Coral Assessment '!E73+'Coral Assessment '!D73+'Coral Assessment '!C73+'Coral Assessment '!I70+'Coral Assessment '!H70+'Coral Assessment '!G70+'Coral Assessment '!F70+'Coral Assessment '!E70+'Coral Assessment '!D70+'Coral Assessment '!C70+'Coral Assessment '!G68+'Coral Assessment '!F68+'Coral Assessment '!E68+'Coral Assessment '!D68+'Coral Assessment '!C68+'Coral Assessment '!G67)*SUM(Justifications!F66:F70)","v":0}]
["Habitat Functions",{"$f":"('Coral Assessment '!C92*SUM(Justifications!D12:D17))","v":0},{"$f":"('Coral Assessment '!D92*SUM(Justifications!E12:E17))","v":0},{"$f":"('Coral Assessment '!E92*SUM(Justifications!F12:F17))","v":0},{"$f":"('Coral Assessment '!F92*SUM(Justifications!G12:G17))","v":0},{"$f":"('Coral Assessment '!G92*SUM(Justifications!H12:H17))","v":0},{"$f":"('Coral Assessment '!H92*SUM(Justifications!I12:I17))","v":0},{"$f":"('Coral Assessment '!I92*SUM(Justifications!J12:J17))","v":0},null,"Habitat Functions",{"$f":"('Coral Assessment '!F110*SUM(Justifications!D42:D47))","v":0},{"$f":"('Coral Assessment '!F118*SUM(Justifications!E42:E47))","v":0},{"$f":"('Coral Assessment '!F102*SUM(Justifications!F42:F47))","v":0},{"$f":"('Coral Assessment '!F142*SUM(Justifications!G42:G47))","v":0},{"$f":"('Coral Assessment '!F164*SUM(Justifications!H42:H47))","v":0},{"$f":"('Coral Assessment '!F134*SUM(Justifications!I42:I47))","v":0},{"$f":"('Coral Assessment '!F158*SUM(Justifications!J42:J47))","v":0},{"$f":"('Coral Assessment '!F126*SUM(Justifications!K42:K47))","v":0},{"$f":"('Coral Assessment '!F150*SUM(Justifications!L42:L47))","v":0},null,"Habitat Functions",{"$f":"SUM('Coral Assessment '!C26+'Coral Assessment '!D26+'Coral Assessment '!E26+'Coral Assessment '!F26+'Coral Assessment '!G26+'Coral Assessment '!H26+'Coral Assessment '!C29+'Coral Assessment '!D29+'Coral Assessment '!E29+'Coral Assessment '!F29+'Coral Assessment '!G29+'Coral Assessment '!H29+'Coral Assessment '!I29+'Coral Assessment '!C31+'Coral Assessment '!D31+'Coral Assessment '!E31+'Coral Assessment '!F31+'Coral Assessment '!G31+'Coral Assessment '!H31+'Coral Assessment '!I31+'Coral Assessment '!C33+'Coral Assessment '!D33+'Coral Assessment '!E33+'Coral Assessment '!F33+'Coral Assessment '!G33+'Coral Assessment '!H33+'Coral Assessment '!I33+'Coral Assessment '!C41+'Coral Assessment '!D41+'Coral Assessment '!E41+'Coral Assessment '!F41+'Coral Assessment '!G41+'Coral Assessment '!H41+'Coral Assessment '!I41+'Coral Assessment '!C44+'Coral Assessment '!D44+'Coral Assessment '!E44+'Coral Assessment '!F44+'Coral Assessment '!G44+'Coral Assessment '!H44+'Coral Assessment '!I44+'Coral Assessment '!C62+'Coral Assessment '!D62+'Coral Assessment '!E62+'Coral Assessment '!F62+'Coral Assessment '!G62+'Coral Assessment '!H62+'Coral Assessment '!I62+'Coral Assessment '!C66+'Coral Assessment '!D66+'Coral Assessment '!E66+'Coral Assessment '!F66+'Coral Assessment '!G66+'Coral Assessment '!H66+'Coral Assessment '!I66+'Coral Assessment '!C70+'Coral Assessment '!D70+'Coral Assessment '!E70+'Coral Assessment '!F70+'Coral Assessment '!G70+'Coral Assessment '!C77+'Coral Assessment '!D77+'Coral Assessment '!E77+'Coral Assessment '!F77+'Coral Assessment '!G77+'Coral Assessment '!C84+'Coral Assessment '!D84+'Coral Assessment '!E84+'Coral Assessment '!C86+'Coral Assessment '!D86+'Coral Assessment '!E86+'Coral Assessment '!F86+'Coral Assessment '!G86+'Coral Assessment '!H86+'Coral Assessment '!I86)*SUM(Justifications!D71:D76)","v":0},{"$f":"SUM('Coral Assessment '!C22+'Coral Assessment '!D22+'Coral Assessment '!E22+'Coral Assessment '!F22+'Coral Assessment '!G22+'Coral Assessment '!H22+'Coral Assessment '!C23+'Coral Assessment '!D23+'Coral Assessment '!E23+'Coral Assessment '!F23+'Coral Assessment '!G23+'Coral Assessment '!H23+'Coral Assessment '!C31+'Coral Assessment '!D31+'Coral Assessment '!E31+'Coral Assessment '!F31+'Coral Assessment '!G31+'Coral Assessment '!H31+'Coral Assessment '!I31+'Coral Assessment '!C38+'Coral Assessment '!D38+'Coral Assessment '!E38+'Coral Assessment '!C39+'Coral Assessment '!D39+'Coral Assessment '!E39+'Coral Assessment '!F39+'Coral Assessment '!G39+'Coral Assessment '!C44+'Coral Assessment '!D44+'Coral Assessment '!E44+'Coral Assessment '!F44+'Coral Assessment '!G44+'Coral Assessment '!H44+'Coral Assessment '!I44+'Coral Assessment '!C45+'Coral Assessment '!D45+'Coral Assessment '!E45+'Coral Assessment '!F45+'Coral Assessment '!G45+'Coral Assessment '!H45+'Coral Assessment '!I45+'Coral Assessment '!C47+'Coral Assessment '!D47+'Coral Assessment '!E47+'Coral Assessment '!F47+'Coral Assessment '!G48+'Coral Assessment '!G47+'Coral Assessment '!H47+'Coral Assessment '!I47+'Coral Assessment '!I48+'Coral Assessment '!H48+'Coral Assessment '!F48+'Coral Assessment '!E48+'Coral Assessment '!D48+'Coral Assessment '!C48+'Coral Assessment '!C49+'Coral Assessment '!D49+'Coral Assessment '!E49+'Coral Assessment '!F49+'Coral Assessment '!G49+'Coral Assessment '!C53+'Coral Assessment '!D53+'Coral Assessment '!E53+'Coral Assessment '!F53+'Coral Assessment '!G53+'Coral Assessment '!H53+'Coral Assessment '!I53+'Coral Assessment '!C54+'Coral Assessment '!D54+'Coral Assessment '!E54+'Coral Assessment '!C59+'Coral Assessment '!D59+'Coral Assessment '!E59+'Coral Assessment '!F59+'Coral Assessment '!G59+'Coral Assessment '!H59+'Coral Assessment '!I59+'Coral Assessment '!C72+'Coral Assessment '!D72+'Coral Assessment '!E72+'Coral Assessment '!C75+'Coral Assessment '!D75+'Coral Assessment '!E75+'Coral Assessment '!F75+'Coral Assessment '!G75+'Coral Assessment '!C78+'Coral Assessment '!D78+'Coral Assessment '!E78+'Coral Assessment '!F78+'Coral Assessment '!G78+'Coral Assessment '!H78+'Coral Assessment '!I78+'Coral Assessment '!C80+'Coral Assessment '!D80+'Coral Assessment '!E80+'Coral Assessment '!F80+'Coral Assessment '!G80+'Coral Assessment '!C82+'Coral Assessment '!D82+'Coral Assessment '!E82+'Coral Assessment '!C87+'Coral Assessment '!D87+'Coral Assessment '!E87+'Coral Assessment '!F87+'Coral Assessment '!G87+'Coral Assessment '!H87+'Coral Assessment '!I87+'Coral Assessment '!C89+'Coral Assessment '!D89+'Coral Assessment '!E89+'Coral Assessment '!F89+'Coral Assessment '!G89+'Coral Assessment '!H89+'Coral Assessment '!I89)*SUM(Justifications!E71:E76)","v":0},{"$f":"SUM('Coral Assessment '!C20+'Coral Assessment '!D20+'Coral Assessment '!E20+'Coral Assessment '!C24+'Coral Assessment '!D24+'Coral Assessment '!E24+'Coral Assessment '!F24+'Coral Assessment '!G24+'Coral Assessment '!H24+'Coral Assessment '!C26+'Coral Assessment '!D26+'Coral Assessment '!E26+'Coral Assessment '!F26+'Coral Assessment '!G26+'Coral Assessment '!H26+'Coral Assessment '!C29+'Coral Assessment '!D29+'Coral Assessment '!E29+'Coral Assessment '!F29+'Coral Assessment '!G29+'Coral Assessment '!H29+'Coral Assessment '!I29+'Coral Assessment '!C33+'Coral Assessment '!D33+'Coral Assessment '!E33+'Coral Assessment '!F33+'Coral Assessment '!G33+'Coral Assessment '!H33+'Coral Assessment '!I33+'Coral Assessment '!C35+'Coral Assessment '!D35+'Coral Assessment '!E35+'Coral Assessment '!F35+'Coral Assessment '!G35+'Coral Assessment '!H35+'Coral Assessment '!I35+'Coral Assessment '!C37+'Coral Assessment '!D37+'Coral Assessment '!E37+'Coral Assessment '!F37+'Coral Assessment '!G37+'Coral Assessment '!H37+'Coral Assessment '!I37+'Coral Assessment '!C41+'Coral Assessment '!D41+'Coral Assessment '!E41+'Coral Assessment '!F41+'Coral Assessment '!G41+'Coral Assessment '!H41+'Coral Assessment '!I41+'Coral Assessment '!C42+'Coral Assessment '!D42+'Coral Assessment '!E42+'Coral Assessment '!F42+'Coral Assessment '!G42+'Coral Assessment '!H42+'Coral Assessment '!I42+'Coral Assessment '!C46+'Coral Assessment '!D46+'Coral Assessment '!E46+'Coral Assessment '!F46+'Coral Assessment '!G46+'Coral Assessment '!H46+'Coral Assessment '!I46+'Coral Assessment '!C51+'Coral Assessment '!D51+'Coral Assessment '!E51+'Coral Assessment '!F51+'Coral Assessment '!G51+'Coral Assessment '!H51+'Coral Assessment '!I51+'Coral Assessment '!C52+'Coral Assessment '!D52+'Coral Assessment '!E52+'Coral Assessment '!F52+'Coral Assessment '!G52+'Coral Assessment '!H52+'Coral Assessment '!I52+'Coral Assessment '!C55+'Coral Assessment '!D55+'Coral Assessment '!E55+'Coral Assessment '!F55+'Coral Assessment '!G55+'Coral Assessment '!H55+'Coral Assessment '!I55+'Coral Assessment '!C56+'Coral Assessment '!D56+'Coral Assessment '!E56+'Coral Assessment '!F56+'Coral Assessment '!G56+'Coral Assessment '!H56+'Coral Assessment '!I56+'Coral Assessment '!C57+'Coral Assessment '!D57+'Coral Assessment '!E57+'Coral Assessment '!F57+'Coral Assessment '!G57+'Coral Assessment '!C60+'Coral Assessment '!D60+'Coral Assessment '!E60+'Coral Assessment '!F60+'Coral Assessment '!G60+'Coral Assessment '!H60+'Coral Assessment '!I60+'Coral Assessment '!C63+'Coral Assessment '!D63+'Coral Assessment '!E63+'Coral Assessment '!F63+'Coral Assessment '!G63+'Coral Assessment '!C64+'Coral Assessment '!D64+'Coral Assessment '!E64+'Coral Assessment '!F64+'Coral Assessment '!G64+'Coral Assessment '!H64+'Coral Assessment '!I64+'Coral Assessment '!C66+'Coral Assessment '!D66+'Coral Assessment '!E66+'Coral Assessment '!F66+'Coral Assessment '!G66+'Coral Assessment '!H66+'Coral Assessment '!I66+'Coral Assessment '!C67+'Coral Assessment '!D67+'Coral Assessment '!E67+'Coral Assessment '!F67+'Coral Assessment '!I88+'Coral Assessment '!H88+'Coral Assessment '!G88+'Coral Assessment '!F88+'Coral Assessment '!E88+'Coral Assessment '!D88+'Coral Assessment '!C88+'Coral Assessment '!I86+'Coral Assessment '!H86+'Coral Assessment '!G86+'Coral Assessment '!F86+'Coral Assessment '!E86+'Coral Assessment '!D86+'Coral Assessment '!C86+'Coral Assessment '!I81+'Coral Assessment '!H81+'Coral Assessment '!G81+'Coral Assessment '!F81+'Coral Assessment '!E81+'Coral Assessment '!D81+'Coral Assessment '!C81+'Coral Assessment '!I79+'Coral Assessment '!H79+'Coral Assessment '!G79+'Coral Assessment '!F79+'Coral Assessment '!E79+'Coral Assessment '!D79+'Coral Assessment '!C79+'Coral Assessment '!E74+'Coral Assessment '!D74+'Coral Assessment '!C74+'Coral Assessment '!E73+'Coral Assessment '!D73+'Coral Assessment '!C73+'Coral Assessment '!I70+'Coral Assessment '!H70+'Coral Assessment '!G70+'Coral Assessment '!F70+'Coral Assessment '!E70+'Coral Assessment '!D70+'Coral Assessment '!C70+'Coral Assessment '!G68+'Coral Assessment '!F68+'Coral Assessment '!E68+'Coral Assessment '!D68+'Coral Assessment '!C68+'Coral Assessment '!G67)*SUM(Justifications!F71:F76)","v":0}]
["Production Services",{"$f":"('Coral Assessment '!C92*SUM(Justifications!D18:D20))","v":0},{"$f":"('Coral Assessment '!D92*SUM(Justifications!E18:E20))","v":0},{"$f":"('Coral Assessment '!E92*SUM(Justifications!F18:F20))","v":0},{"$f":"('Coral Assessment '!F92*SUM(Justifications!G18:G20))","v":0},{"$f":"('Coral Assessment '!G92*SUM(Justifications!H18:H20))","v":0},{"$f":"('Coral Assessment '!H92*SUM(Justifications!I18:I20))","v":0},{"$f":"('Coral Assessment '!I92*SUM(Justifications!J18:J20))","v":0},null,"Production Services",{"$f":"('Coral Assessment '!F110*SUM(Justifications!D48:D50))","v":0},{"$f":"('Coral Assessment '!F118*SUM(Justifications!E48:E50))","v":0},{"$f":"('Coral Assessment '!F102*SUM(Justifications!F48:F50))","v":0},{"$f":"('Coral Assessment '!F142*SUM(Justifications!G48:G50))","v":0},{"$f":"('Coral Assessment '!F164*SUM(Justifications!H48:H50))","v":0},{"$f":"('Coral Assessment '!F134*SUM(Justifications!I48:I50))","v":0},{"$f":"('Coral Assessment '!F158*SUM(Justifications!J48:J50))","v":0},{"$f":"('Coral Assessment '!F126*SUM(Justifications!K48:K50))","v":0},{"$f":"('Coral Assessment '!F150*SUM(Justifications!L48:L50))","v":0},null,"Production Services",{"$f":"SUM('Coral Assessment '!C27+'Coral Assessment '!D27+'Coral Assessment '!E27+'Coral Assessment '!F27+'Coral Assessment '!G27+'Coral Assessment '!H27+'Coral Assessment '!C30+'Coral Assessment '!D30+'Coral Assessment '!E30+'Coral Assessment '!F30+'Coral Assessment '!G30+'Coral Assessment '!H30+'Coral Assessment '!I30+'Coral Assessment '!C32+'Coral Assessment '!D32+'Coral Assessment '!E32+'Coral Assessment '!F32+'Coral Assessment '!G32+'Coral Assessment '!H32+'Coral Assessment '!I32+'Coral Assessment '!C34+'Coral Assessment '!D34+'Coral Assessment '!E34+'Coral Assessment '!F34+'Coral Assessment '!G34+'Coral Assessment '!H34+'Coral Assessment '!I34+'Coral Assessment '!C42+'Coral Assessment '!D42+'Coral Assessment '!E42+'Coral Assessment '!F42+'Coral Assessment '!G42+'Coral Assessment '!H42+'Coral Assessment '!I42+'Coral Assessment '!C45+'Coral Assessment '!D45+'Coral Assessment '!E45+'Coral Assessment '!F45+'Coral Assessment '!G45+'Coral Assessment '!H45+'Coral Assessment '!I45+'Coral Assessment '!C63+'Coral Assessment '!D63+'Coral Assessment '!E63+'Coral Assessment '!F63+'Coral Assessment '!G63+'Coral Assessment '!H63+'Coral Assessment '!I63+'Coral Assessment '!C67+'Coral Assessment '!D67+'Coral Assessment '!E67+'Coral Assessment '!F67+'Coral Assessment '!G67+'Coral Assessment '!H67+'Coral Assessment '!I67+'Coral Assessment '!C71+'Coral Assessment '!D71+'Coral Assessment '!E71+'Coral Assessment '!F71+'Coral Assessment '!G71+'Coral Assessment '!C78+'Coral Assessment '!D78+'Coral Assessment '!E78+'Coral Assessment '!F78+'Coral Assessment '!G78+'Coral Assessment '!C85+'Coral Assessment '!D85+'Coral Assessment '!E85+'Coral Assessment '!C87+'Coral Assessment '!D87+'Coral Assessment '!E87+'Coral Assessment '!F87+'Coral Assessment '!G87+'Coral Assessment '!H87+'Coral Assessment '!I87)*SUM(Justifications!D77:D79)","v":0},{"$f":"SUM('Coral Assessment '!C22+'Coral Assessment '!D22+'Coral Assessment '!E22+'Coral Assessment '!F22+'Coral Assessment '!G22+'Coral Assessment '!H22+'Coral Assessment '!C23+'Coral Assessment '!D23+'Coral Assessment '!E23+'Coral Assessment '!F23+'Coral Assessment '!G23+'Coral Assessment '!H23+'Coral Assessment '!C31+'Coral Assessment '!D31+'Coral Assessment '!E31+'Coral Assessment '!F31+'Coral Assessment '!G31+'Coral Assessment '!H31+'Coral Assessment '!I31+'Coral Assessment '!C38+'Coral Assessment '!D38+'Coral Assessment '!E38+'Coral Assessment '!C39+'Coral Assessment '!D39+'Coral Assessment '!E39+'Coral Assessment '!F39+'Coral Assessment '!G39+'Coral Assessment '!C44+'Coral Assessment '!D44+'Coral Assessment '!E44+'Coral Assessment '!F44+'Coral Assessment '!G44+'Coral Assessment '!H44+'Coral Assessment '!I44+'Coral Assessment '!C45+'Coral Assessment '!D45+'Coral Assessment '!E45+'Coral Assessment '!F45+'Coral Assessment '!G45+'Coral Assessment '!H45+'Coral Assessment '!I45+'Coral Assessment '!C47+'Coral Assessment '!D47+'Coral Assessment '!E47+'Coral Assessment '!F47+'Coral Assessment '!G48+'Coral Assessment '!G47+'Coral Assessment '!H47+'Coral Assessment '!I47+'Coral Assessment '!I48+'Coral Assessment '!H48+'Coral Assessment '!F48+'Coral Assessment '!E48+'Coral Assessment '!D48+'Coral Assessment '!C48+'Coral Assessment '!C49+'Coral Assessment '!D49+'Coral Assessment '!E49+'Coral Assessment '!F49+'Coral Assessment '!G49+'Coral Assessment '!C53+'Coral Assessment '!D53+'Coral Assessment '!E53+'Coral Assessment '!F53+'Coral Assessment '!G53+'Coral Assessment '!H53+'Coral Assessment '!I53+'Coral Assessment '!C54+'Coral Assessment '!D54+'Coral Assessment '!E54+'Coral Assessment '!C59+'Coral Assessment '!D59+'Coral Assessment '!E59+'Coral Assessment '!F59+'Coral Assessment '!G59+'Coral Assessment '!H59+'Coral Assessment '!I59+'Coral Assessment '!C72+'Coral Assessment '!D72+'Coral Assessment '!E72+'Coral Assessment '!C75+'Coral Assessment '!D75+'Coral Assessment '!E75+'Coral Assessment '!F75+'Coral Assessment '!G75+'Coral Assessment '!C78+'Coral Assessment '!D78+'Coral Assessment '!E78+'Coral Assessment '!F78+'Coral Assessment '!G78+'Coral Assessment '!H78+'Coral Assessment '!I78+'Coral Assessment '!C80+'Coral Assessment '!D80+'Coral Assessment '!E80+'Coral Assessment '!F80+'Coral Assessment '!G80+'Coral Assessment '!C82+'Coral Assessment '!D82+'Coral Assessment '!E82+'Coral Assessment '!C87+'Coral Assessment '!D87+'Coral Assessment '!E87+'Coral Assessment '!F87+'Coral Assessment '!G87+'Coral Assessment '!H87+'Coral Assessment '!I87+'Coral Assessment '!C89+'Coral Assessment '!D89+'Coral Assessment '!E89+'Coral Assessment '!F89+'Coral Assessment '!G89+'Coral Assessment '!H89+'Coral Assessment '!I89)*SUM(Justifications!E77:E79)","v":0},{"$f":"SUM('Coral Assessment '!C20+'Coral Assessment '!D20+'Coral Assessment '!E20+'Coral Assessment '!C24+'Coral Assessment '!D24+'Coral Assessment '!E24+'Coral Assessment '!F24+'Coral Assessment '!G24+'Coral Assessment '!H24+'Coral Assessment '!C26+'Coral Assessment '!D26+'Coral Assessment '!E26+'Coral Assessment '!F26+'Coral Assessment '!G26+'Coral Assessment '!H26+'Coral Assessment '!C29+'Coral Assessment '!D29+'Coral Assessment '!E29+'Coral Assessment '!F29+'Coral Assessment '!G29+'Coral Assessment '!H29+'Coral Assessment '!I29+'Coral Assessment '!C33+'Coral Assessment '!D33+'Coral Assessment '!E33+'Coral Assessment '!F33+'Coral Assessment '!G33+'Coral Assessment '!H33+'Coral Assessment '!I33+'Coral Assessment '!C35+'Coral Assessment '!D35+'Coral Assessment '!E35+'Coral Assessment '!F35+'Coral Assessment '!G35+'Coral Assessment '!H35+'Coral Assessment '!I35+'Coral Assessment '!C37+'Coral Assessment '!D37+'Coral Assessment '!E37+'Coral Assessment '!F37+'Coral Assessment '!G37+'Coral Assessment '!H37+'Coral Assessment '!I37+'Coral Assessment '!C41+'Coral Assessment '!D41+'Coral Assessment '!E41+'Coral Assessment '!F41+'Coral Assessment '!G41+'Coral Assessment '!H41+'Coral Assessment '!I41+'Coral Assessment '!C42+'Coral Assessment '!D42+'Coral Assessment '!E42+'Coral Assessment '!F42+'Coral Assessment '!G42+'Coral Assessment '!H42+'Coral Assessment '!I42+'Coral Assessment '!C46+'Coral Assessment '!D46+'Coral Assessment '!E46+'Coral Assessment '!F46+'Coral Assessment '!G46+'Coral Assessment '!H46+'Coral Assessment '!I46+'Coral Assessment '!C51+'Coral Assessment '!D51+'Coral Assessment '!E51+'Coral Assessment '!F51+'Coral Assessment '!G51+'Coral Assessment '!H51+'Coral Assessment '!I51+'Coral Assessment '!C52+'Coral Assessment '!D52+'Coral Assessment '!E52+'Coral Assessment '!F52+'Coral Assessment '!G52+'Coral Assessment '!H52+'Coral Assessment '!I52+'Coral Assessment '!C55+'Coral Assessment '!D55+'Coral Assessment '!E55+'Coral Assessment '!F55+'Coral Assessment '!G55+'Coral Assessment '!H55+'Coral Assessment '!I55+'Coral Assessment '!C56+'Coral Assessment '!D56+'Coral Assessment '!E56+'Coral Assessment '!F56+'Coral Assessment '!G56+'Coral Assessment '!H56+'Coral Assessment '!I56+'Coral Assessment '!C57+'Coral Assessment '!D57+'Coral Assessment '!E57+'Coral Assessment '!F57+'Coral Assessment '!G57+'Coral Assessment '!C60+'Coral Assessment '!D60+'Coral Assessment '!E60+'Coral Assessment '!F60+'Coral Assessment '!G60+'Coral Assessment '!H60+'Coral Assessment '!I60+'Coral Assessment '!C63+'Coral Assessment '!D63+'Coral Assessment '!E63+'Coral Assessment '!F63+'Coral Assessment '!G63+'Coral Assessment '!C64+'Coral Assessment '!D64+'Coral Assessment '!E64+'Coral Assessment '!F64+'Coral Assessment '!G64+'Coral Assessment '!H64+'Coral Assessment '!I64+'Coral Assessment '!C66+'Coral Assessment '!D66+'Coral Assessment '!E66+'Coral Assessment '!F66+'Coral Assessment '!G66+'Coral Assessment '!H66+'Coral Assessment '!I66+'Coral Assessment '!C67+'Coral Assessment '!D67+'Coral Assessment '!E67+'Coral Assessment '!F67+'Coral Assessment '!I88+'Coral Assessment '!H88+'Coral Assessment '!G88+'Coral Assessment '!F88+'Coral Assessment '!E88+'Coral Assessment '!D88+'Coral Assessment '!C88+'Coral Assessment '!I86+'Coral Assessment '!H86+'Coral Assessment '!G86+'Coral Assessment '!F86+'Coral Assessment '!E86+'Coral Assessment '!D86+'Coral Assessment '!C86+'Coral Assessment '!I81+'Coral Assessment '!H81+'Coral Assessment '!G81+'Coral Assessment '!F81+'Coral Assessment '!E81+'Coral Assessment '!D81+'Coral Assessment '!C81+'Coral Assessment '!I79+'Coral Assessment '!H79+'Coral Assessment '!G79+'Coral Assessment '!F79+'Coral Assessment '!E79+'Coral Assessment '!D79+'Coral Assessment '!C79+'Coral Assessment '!E74+'Coral Assessment '!D74+'Coral Assessment '!C74+'Coral Assessment '!E73+'Coral Assessment '!D73+'Coral Assessment '!C73+'Coral Assessment '!I70+'Coral Assessment '!H70+'Coral Assessment '!G70+'Coral Assessment '!F70+'Coral Assessment '!E70+'Coral Assessment '!D70+'Coral Assessment '!C70+'Coral Assessment '!G68+'Coral Assessment '!F68+'Coral Assessment '!E68+'Coral Assessment '!D68+'Coral Assessment '!C68+'Coral Assessment '!G67)*SUM(Justifications!F77:F79)","v":0}]
["Information Services",{"$f":"('Coral Assessment '!C92*SUM(Justifications!D21:D28))","v":0},{"$f":"('Coral Assessment '!D92*SUM(Justifications!E21:E28))","v":0},{"$f":"('Coral Assessment '!E92*SUM(Justifications!F21:F28))","v":0},{"$f":"('Coral Assessment '!F92*SUM(Justifications!G21:G28))","v":0},{"$f":"('Coral Assessment '!G92*SUM(Justifications!H21:H28))","v":0},{"$f":"('Coral Assessment '!H92*SUM(Justifications!I21:I28))","v":0},{"$f":"('Coral Assessment '!I92*SUM(Justifications!J21:J28))","v":0},null,"Information Services",{"$f":"('Coral Assessment '!F110*SUM(Justifications!D51:D58))","v":0},{"$f":"('Coral Assessment '!F118*SUM(Justifications!E51:E58))","v":0},{"$f":"('Coral Assessment '!F102*SUM(Justifications!F51:F58))","v":0},{"$f":"('Coral Assessment '!F142*SUM(Justifications!G51:G58))","v":0},{"$f":"('Coral Assessment '!F164*SUM(Justifications!H51:H58))","v":0},{"$f":"('Coral Assessment '!F134*SUM(Justifications!I51:I58))","v":0},{"$f":"('Coral Assessment '!F158*SUM(Justifications!J51:J58))","v":0},{"$f":"('Coral Assessment '!F126*SUM(Justifications!K51:K58))","v":0},{"$f":"('Coral Assessment '!F150*SUM(Justifications!L51:L58))","v":0},null,"Information Services",{"$f":"SUM('Coral Assessment '!C28+'Coral Assessment '!D28+'Coral Assessment '!E28+'Coral Assessment '!F28+'Coral Assessment '!G28+'Coral Assessment '!H28+'Coral Assessment '!C31+'Coral Assessment '!D31+'Coral Assessment '!E31+'Coral Assessment '!F31+'Coral Assessment '!G31+'Coral Assessment '!H31+'Coral Assessment '!I31+'Coral Assessment '!C33+'Coral Assessment '!D33+'Coral Assessment '!E33+'Coral Assessment '!F33+'Coral Assessment '!G33+'Coral Assessment '!H33+'Coral Assessment '!I33+'Coral Assessment '!C35+'Coral Assessment '!D35+'Coral Assessment '!E35+'Coral Assessment '!F35+'Coral Assessment '!G35+'Coral Assessment '!H35+'Coral Assessment '!I35+'Coral Assessment '!C43+'Coral Assessment '!D43+'Coral Assessment '!E43+'Coral Assessment '!F43+'Coral Assessment '!G43+'Coral Assessment '!H43+'Coral Assessment '!I43+'Coral Assessment '!C46+'Coral Assessment '!D46+'Coral Assessment '!E46+'Coral Assessment '!F46+'Coral Assessment '!G46+'Coral Assessment '!H46+'Coral Assessment '!I46+'Coral Assessment '!C64+'Coral Assessment '!D64+'Coral Assessment '!E64+'Coral Assessment '!F64+'Coral Assessment '!G64+'Coral Assessment '!H64+'Coral Assessment '!I64+'Coral Assessment '!C68+'Coral Assessment '!D68+'Coral Assessment '!E68+'Coral Assessment '!F68+'Coral Assessment '!G68+'Coral Assessment '!H68+'Coral Assessment '!I68+'Coral Assessment '!C72+'Coral Assessment '!D72+'Coral Assessment '!E72+'Coral Assessment '!F72+'Coral Assessment '!G72+'Coral Assessment '!C79+'Coral Assessment '!D79+'Coral Assessment '!E79+'Coral Assessment '!F79+'Coral Assessment '!G79+'Coral Assessment '!C86+'Coral Assessment '!D86+'Coral Assessment '!E86+'Coral Assessment '!C88+'Coral Assessment '!D88+'Coral Assessment '!E88+'Coral Assessment '!F88+'Coral Assessment '!G88+'Coral Assessment '!H88+'Coral Assessment '!I88)*SUM(Justifications!D80:D87)","v":0},{"$f":"SUM('Coral Assessment '!C22+'Coral Assessment '!D22+'Coral Assessment '!E22+'Coral Assessment '!F22+'Coral Assessment '!G22+'Coral Assessment '!H22+'Coral Assessment '!C23+'Coral Assessment '!D23+'Coral Assessment '!E23+'Coral Assessment '!F23+'Coral Assessment '!G23+'Coral Assessment '!H23+'Coral Assessment '!C31+'Coral Assessment '!D31+'Coral Assessment '!E31+'Coral Assessment '!F31+'Coral Assessment '!G31+'Coral Assessment '!H31+'Coral Assessment '!I31+'Coral Assessment '!C38+'Coral Assessment '!D38+'Coral Assessment '!E38+'Coral Assessment '!C39+'Coral Assessment '!D39+'Coral Assessment '!E39+'Coral Assessment '!F39+'Coral Assessment '!G39+'Coral Assessment '!C44+'Coral Assessment '!D44+'Coral Assessment '!E44+'Coral Assessment '!F44+'Coral Assessment '!G44+'Coral Assessment '!H44+'Coral Assessment '!I44+'Coral Assessment '!C45+'Coral Assessment '!D45+'Coral Assessment '!E45+'Coral Assessment '!F45+'Coral Assessment '!G45+'Coral Assessment '!H45+'Coral Assessment '!I45+'Coral Assessment '!C47+'Coral Assessment '!D47+'Coral Assessment '!E47+'Coral Assessment '!F47+'Coral Assessment '!G48+'Coral Assessment '!G47+'Coral Assessment '!H47+'Coral Assessment '!I47+'Coral Assessment '!I48+'Coral Assessment '!H48+'Coral Assessment '!F48+'Coral Assessment '!E48+'Coral Assessment '!D48+'Coral Assessment '!C48+'Coral Assessment '!C49+'Coral Assessment '!D49+'Coral Assessment '!E49+'Coral Assessment '!F49+'Coral Assessment '!G49+'Coral Assessment '!C53+'Coral Assessment '!D53+'Coral Assessment '!E53+'Coral Assessment '!F53+'Coral Assessment '!G53+'Coral Assessment '!H53+'Coral Assessment '!I53+'Coral Assessment '!C54+'Coral Assessment '!D54+'Coral Assessment '!E54+'Coral Assessment '!C59+'Coral Assessment '!D59+'Coral Assessment '!E59+'Coral Assessment '!F59+'Coral Assessment '!G59+'Coral Assessment '!H59+'Coral Assessment '!I59+'Coral Assessment '!C72+'Coral Assessment '!D72+'Coral Assessment '!E72+'Coral Assessment '!C75+'Coral Assessment '!D75+'Coral Assessment '!E75+'Coral Assessment '!F75+'Coral Assessment '!G75+'Coral Assessment '!C78+'Coral Assessment '!D78+'Coral Assessment '!E78+'Coral Assessment '!F78+'Coral Assessment '!G78+'Coral Assessment '!H78+'Coral Assessment '!I78+'Coral Assessment '!C80+'Coral Assessment '!D80+'Coral Assessment '!E80+'Coral Assessment '!F80+'Coral Assessment '!G80+'Coral Assessment '!C82+'Coral Assessment '!D82+'Coral Assessment '!E82+'Coral Assessment '!C87+'Coral Assessment '!D87+'Coral Assessment '!E87+'Coral Assessment '!F87+'Coral Assessment '!G87+'Coral Assessment '!H87+'Coral Assessment '!I87+'Coral Assessment '!C89+'Coral Assessment '!D89+'Coral Assessment '!E89+'Coral Assessment '!F89+'Coral Assessment '!G89+'Coral Assessment '!H89+'Coral Assessment '!I89)*SUM(Justifications!E80:E87)","v":0},{"$f":"SUM('Coral Assessment '!C20+'Coral Assessment '!D20+'Coral Assessment '!E20+'Coral Assessment '!C24+'Coral Assessment '!D24+'Coral Assessment '!E24+'Coral Assessment '!F24+'Coral Assessment '!G24+'Coral Assessment '!H24+'Coral Assessment '!C26+'Coral Assessment '!D26+'Coral Assessment '!E26+'Coral Assessment '!F26+'Coral Assessment '!G26+'Coral Assessment '!H26+'Coral Assessment '!C29+'Coral Assessment '!D29+'Coral Assessment '!E29+'Coral Assessment '!F29+'Coral Assessment '!G29+'Coral Assessment '!H29+'Coral Assessment '!I29+'Coral Assessment '!C33+'Coral Assessment '!D33+'Coral Assessment '!E33+'Coral Assessment '!F33+'Coral Assessment '!G33+'Coral Assessment '!H33+'Coral Assessment '!I33+'Coral Assessment '!C35+'Coral Assessment '!D35+'Coral Assessment '!E35+'Coral Assessment '!F35+'Coral Assessment '!G35+'Coral Assessment '!H35+'Coral Assessment '!I35+'Coral Assessment '!C37+'Coral Assessment '!D37+'Coral Assessment '!E37+'Coral Assessment '!F37+'Coral Assessment '!G37+'Coral Assessment '!H37+'Coral Assessment '!I37+'Coral Assessment '!C41+'Coral Assessment '!D41+'Coral Assessment '!E41+'Coral Assessment '!F41+'Coral Assessment '!G41+'Coral Assessment '!H41+'Coral Assessment '!I41+'Coral Assessment '!C42+'Coral Assessment '!D42+'Coral Assessment '!E42+'Coral Assessment '!F42+'Coral Assessment '!G42+'Coral Assessment '!H42+'Coral Assessment '!I42+'Coral Assessment '!C46+'Coral Assessment '!D46+'Coral Assessment '!E46+'Coral Assessment '!F46+'Coral Assessment '!G46+'Coral Assessment '!H46+'Coral Assessment '!I46+'Coral Assessment '!C51+'Coral Assessment '!D51+'Coral Assessment '!E51+'Coral Assessment '!F51+'Coral Assessment '!G51+'Coral Assessment '!H51+'Coral Assessment '!I51+'Coral Assessment '!C52+'Coral Assessment '!D52+'Coral Assessment '!E52+'Coral Assessment '!F52+'Coral Assessment '!G52+'Coral Assessment '!H52+'Coral Assessment '!I52+'Coral Assessment '!C55+'Coral Assessment '!D55+'Coral Assessment '!E55+'Coral Assessment '!F55+'Coral Assessment '!G55+'Coral Assessment '!H55+'Coral Assessment '!I55+'Coral Assessment '!C56+'Coral Assessment '!D56+'Coral Assessment '!E56+'Coral Assessment '!F56+'Coral Assessment '!G56+'Coral Assessment '!H56+'Coral Assessment '!I56+'Coral Assessment '!C57+'Coral Assessment '!D57+'Coral Assessment '!E57+'Coral Assessment '!F57+'Coral Assessment '!G57+'Coral Assessment '!C60+'Coral Assessment '!D60+'Coral Assessment '!E60+'Coral Assessment '!F60+'Coral Assessment '!G60+'Coral Assessment '!H60+'Coral Assessment '!I60+'Coral Assessment '!C63+'Coral Assessment '!D63+'Coral Assessment '!E63+'Coral Assessment '!F63+'Coral Assessment '!G63+'Coral Assessment '!C64+'Coral Assessment '!D64+'Coral Assessment '!E64+'Coral Assessment '!F64+'Coral Assessment '!G64+'Coral Assessment '!H64+'Coral Assessment '!I64+'Coral Assessment '!C66+'Coral Assessment '!D66+'Coral Assessment '!E66+'Coral Assessment '!F66+'Coral Assessment '!G66+'Coral Assessment '!H66+'Coral Assessment '!I66+'Coral Assessment '!C67+'Coral Assessment '!D67+'Coral Assessment '!E67+'Coral Assessment '!F67+'Coral Assessment '!I88+'Coral Assessment '!H88+'Coral Assessment '!G88+'Coral Assessment '!F88+'Coral Assessment '!E88+'Coral Assessment '!D88+'Coral Assessment '!C88+'Coral Assessment '!I86+'Coral Assessment '!H86+'Coral Assessment '!G86+'Coral Assessment '!F86+'Coral Assessment '!E86+'Coral Assessment '!D86+'Coral Assessment '!C86+'Coral Assessment '!I81+'Coral Assessment '!H81+'Coral Assessment '!G81+'Coral Assessment '!F81+'Coral Assessment '!E81+'Coral Assessment '!D81+'Coral Assessment '!C81+'Coral Assessment '!I79+'Coral Assessment '!H79+'Coral Assessment '!G79+'Coral Assessment '!F79+'Coral Assessment '!E79+'Coral Assessment '!D79+'Coral Assessment '!C79+'Coral Assessment '!E74+'Coral Assessment '!D74+'Coral Assessment '!C74+'Coral Assessment '!E73+'Coral Assessment '!D73+'Coral Assessment '!C73+'Coral Assessment '!I70+'Coral Assessment '!H70+'Coral Assessment '!G70+'Coral Assessment '!F70+'Coral Assessment '!E70+'Coral Assessment '!D70+'Coral Assessment '!C70+'Coral Assessment '!G68+'Coral Assessment '!F68+'Coral Assessment '!E68+'Coral Assessment '!D68+'Coral Assessment '!C68+'Coral Assessment '!G67)*SUM(Justifications!F80:F87)","v":0}]
["Temporal Loss",{"$f":"('Coral Assessment '!C92*SUM(Justifications!D29:D29))","v":0},{"$f":"('Coral Assessment '!D92*SUM(Justifications!E29:E29))","v":0},{"$f":"('Coral Assessment '!E92*SUM(Justifications!F29:F29))","v":0},{"$f":"('Coral Assessment '!F92*SUM(Justifications!G29:G29))","v":0},{"$f":"('Coral Assessment '!G92*SUM(Justifications!H29:H29))","v":0},{"$f":"('Coral Assessment '!H92*SUM(Justifications!I29:I29))","v":0},{"$f":"('Coral Assessment '!I92*SUM(Justifications!J29:J29))","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Created by Dave Gulko (2023), after State of Hawai‘i version created by D Gulko (2016)."]

{"sheet":"Risk Assessment","index":7,"n_rows":68,"n_cols":17,"rows_kept":68,"cut":false,"hidden":true,"merged":[[67,2,67,5],[53,2,53,10],[54,2,54,9],[55,2,55,9],[56,2,56,9],[59,2,59,9],[60,2,60,9],[58,1,58,6],[61,2,61,9],[57,3,57,6],[40,5,43,5],[62,2,62,9],[38,7,38,10],[31,5,31,7],[1,3,2,8],[7,2,7,5],[33,5,33,7]]}
[]
[null,null,null,"NOTE: The following Risk Assessment Tool is intended for DAR use when evaluating an impact event relative to determining how to address the Responsible Party's actions and seek compensation, penalty, etc. It is primarily designed for Unplanned Events."]
[]
[]
[null,null,null,"Coral Impact                                     Risk Assessment",null,"Designed primarily for unplanned events.",null,null,null,null,null,null,"reg","Prop","Sever"]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('Coral Assessment '!H4=\" \",0.5,IF('Coral Assessment '!H4=0,0.5,IF('Coral Assessment '!E189<0.5,0.5,IF('Coral Assessment '!E189<1,1,IF('Coral Assessment '!E189<2,2,IF('Coral Assessment '!E189>=2,3,0.5))))))","v":0.5},{"$f":"M6","v":0.5},null,"Spp Rich"]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('Coral Assessment '!E191<0,'Coral Assessment '!E191*-1,'Coral Assessment '!E191)","v":0},null,{"$f":"M7","v":0},"Spp Diversity"]
[null,null,"Answer the following questions(in the yellow, pull-down menu boxes provided) regarding the activities already listed:"]
[]
[null,1,null,"What is the type of habitat affected?",null,{"$f":"'Coral Assessment '!F3","v":" "},null,null,null,null,null,null,{"$f":"'Coral Assessment '!O11","v":0},null,{"$f":"M10","v":0},"Habitat"]
[]
[null,2,null,"Was the affected area an MPA?",null,null,null,null,null,null,null,null,{"$f":"IF(F12=\"Fisheries Management Area (FMA)\",2,IF(F12=\"Marine Life Conservation District (MLCD)\",3,IF(F12=\"Marine Refuge, NARS, NWHI Refuge\",4,IF(F12=\"Ocean Recreation Management Area (ORMA)\",2,1))))","v":1},{"$f":"M12","v":1},{"$f":"M12","v":1},"MPA"]
[]
[null,3,null,"Was there documentation that the Responsible Party was officially directed to either cease the impact activity or not conduct the impact activity and disregarded the direction?",null,null,null,null,null,null,null,null,{"$f":"IF(F14=\"Yes\",4,IF(F14=\"Unknown\",2,1))","v":1},{"$f":"M14","v":1},null,"RP Cease"]
[]
[null,4,null,"Was there official documentation of other civil or criminal violations conducted by the Responsible Party at the site of impact?",null,null,null,null,null,null,null,null,{"$f":"IF(F16=\"Criminal\",3,IF(F16=\"Civil\",2,IF(F16=\"Unknown\",2,1)))","v":1},null,{"$f":"M16","v":1},"RP Crime"]
[]
[null,5,null,"Area of impact (in meters squared)?",null,{"$f":"'Coral Assessment '!H4","v":0},null,null,null,null,null,null,{"$f":"IF(F18<1,0.5,IF(F18<3,1,IF(F18<10,2,IF(F18>=10,3,0))))","v":0.5},{"$f":"M18","v":0.5},{"$f":"M18","v":0.5},"AreaImpact"]
[]
[null,6,null,"Number of coral colonies affected?",null,{"$f":"'Coral Assessment '!D177","v":0},null,null,null,null,null,null,{"$f":"IF(F20<5,0.5,IF(F20<10,1,IF(F20<20,2,3)))","v":0.5},{"$f":"M20","v":0.5},{"$f":"M20","v":0.5},"#Colonies"]
[]
[null,7,null,"Maximum coral colony size impacted?",null,null,null,null,null,null,null,null,{"$f":"IF(F22=\"Less than 20 cm\",0.5,IF(F22=\"Between 20 cm and 80 cm\",1,IF(F22=\"Greater than 80 cm\",3,0.5)))","v":0.5},{"$f":"M22","v":0.5},{"$f":"M22","v":0.5},"MaxColSz"]
[]
[null,8,null,"Total coral colony ecological charecterization value per meter squared?",null,{"$f":"'Coral Assessment '!D18","v":0},null,null,null,null,null,null,{"$f":"IF(F24<10,0.5,IF(F24<50,1,IF(F24<100,2,3)))","v":0.5},{"$f":"M24","v":0.5},{"$f":"M24","v":0.5},"EcolChar/M2"]
[]
[null,9,null,"How long was the impact event occurring?",null,null,null,null,null,null,null,null,{"$f":"IF(F26=\"< 1Day\",1,IF(F26=\"< 1 Week\",2,IF(F26=\"< 1 Month\",3,IF(F26=\"< 1 Year\",4,IF(F26=\"Permanent\",5,0.5)))))","v":0.5},{"$f":"M26","v":0.5},{"$f":"M26","v":0.5},"ImpactTime"]
[]
[null,10,null,"Were direct impacts documented to  other natural resources (fish, other invertebrates, other substrate, water quality, etc.)?",null,null,null,null,null,null,null,null,{"$f":"IF(F28=\"Yes\",3,IF(F28=\"Unknown\",2,1))","v":1},{"$f":"M28","v":1},null,"OthrSpp"]
[]
[]
[]
[null,null,null,"Total Coral Ecological Charecterization Score:",null,{"$f":"'Coral Assessment '!C177","v":0},null,null,null,null,null,null,{"$f":"M28+M26+M24+M22+M20+M18+M16+M14+M12+M10+M7+M6","v":7},{"$f":"N28+N26+N24+N22+N20+N18+N14+N12+N6","v":6},{"$f":"O26+O24+O22+O20+O18+O16+O12+O10+O7","v":4.5}]
[]
[null,null,null,"For the project type:",null,{"$f":"'Coral Assessment '!D5","v":0}]
[]
[null,null,null,"The DAR Coral Ecological Charecterization Risk Assessment Score is:",null,{"$f":"IF(M32<=8,0,M32)","v":0}]
[]
[null,null,null,"The Modified Tiered Risk Assessment Score is Highlighted Below:"]
[null,null,null,null,null,null,null,"Probability of Significant Impact to Ecological Services and Functions"]
[null,null,null,{"$f":"IF((Q60+Q59+P60+P59+Q58+Q57+Q56+Q55+P58+P57+O60+O59)>3,'RA Numbers'!A37,IF(('Risk Assessment'!N60+'Risk Assessment'!N59+'Risk Assessment'!O58+'Risk Assessment'!O57+'Risk Assessment'!P56+'Risk Assessment'!P55+'Risk Assessment'!Q54+'Risk Assessment'!Q53)>3,'RA Numbers'!A36,IF(('Risk Assessment'!N58+'Risk Assessment'!N57+'Risk Assessment'!O56+'Risk Assessment'!O55+'Risk Assessment'!P54+'Risk Assessment'!P53+'Risk Assessment'!N56+'Risk Assessment'!N55+'Risk Assessment'!O54+'Risk Assessment'!O53+'Risk Assessment'!N54+'Risk Assessment'!N53)>3,'RA Numbers'!A35,'RA Numbers'!A37)))","v":"RISK IS LOW"},null,null,null,"A","B","C","D"]
[null,null,null,{"$f":"IF(M41+M42=1,'RA Numbers'!A26,IF(M43=1,'RA Numbers'!A27, IF(M44+N44=1,'RA Numbers'!A28,\" \")))","v":" "},null,"Severity of Impact to Ecological Services and Functions","I",{"$f":"IF(N54+N53=2,\"X\",\" \")","v":" "},{"$f":"IF(O54+O53=2,\"X\",\" \")","v":" "},{"$f":"IF(P54+P53=2,\"X\",\" \")","v":" "},{"$f":"IF(Q54+Q53=2,\"X\",\" \")","v":" "},null,{"$f":"IF(H42=\"X\",1,IF(H41=\"X\",1,IF(I41=\"X\",1,0)))","v":0}]
[null,null,null,{"$f":"IF(M42=1,'RA Numbers'!A53,IF(M41=1,'RA Numbers'!A30,\" \"))","v":" "},null,null,"II",{"$f":"IF(N56+N55=2,\"X\",\" \")","v":" "},{"$f":"IF(O55+O56=2,\"X\",\" \")","v":" "},{"$f":"IF(P55+P56=2,\"X\",\" \")","v":" "},{"$f":"IF(Q56+Q55=2,\"X\",\" \")","v":" "},null,{"$f":"IF(H43=\"X\",1,IF(I42=\"X\",1,IF(J41=\"X\",1,0)))","v":0}]
[null,null,null,{"$f":"IF(M41+M42=1,'RA Numbers'!A31,IF(N44+M43=1,'RA Numbers'!A32, IF(M44=1,'RA Numbers'!A33,\" \")))","v":" "},null,null,"III",{"$f":"IF(N58+N57=2,\"X\",\" \")","v":" "},{"$f":"IF(O57+O58=2,\"X\",\" \")","v":" "},{"$f":"IF(P58+P58=2,\"X\",\" \")","v":" "},{"$f":"IF(Q58+Q57=2,\"X\",\" \")","v":" "},null,{"$f":"IF(H44=\"X\",1,IF(I43=\"X\",1,IF(J42=\"X\",1,IF(K41=\"X\",1,0))))","v":0}]
[null,null,null,{"$f":"IF(F34=0,\" \", IF(F34=\"Damaged Area (Unplanned Event)\",\" \",\"Results may not be applicable as this Risk Assessment is designed for Unplanned Events\"))","v":" "},null,null,"IV",{"$f":"IF(N60+N59=2,\"X\",\" \")","v":" "},{"$f":"IF(O60+O59=2,\"X\",\" \")","v":" "},{"$f":"IF(P60+P59=2,\"X\",\" \")","v":" "},{"$f":"IF(Q60+Q59=2,\"X\",\" \")","v":" "},null,{"$f":"IF(K44=\"X\",1,IF(J44=\"X\",1,IF(K43=\"X\",1,0)))","v":0},{"$f":"IF(I44=\"X\",1,IF(J43=\"X\",1,IF(K42=\"X\",1,0)))","v":0}]
[]
[null,"Criteria:",null,null,null,null,"Coral Impact  Risk Assessment Score:"]
[null,null,"Tier 1 = Critical – Very High Risk",null,null,null,null,"HIGH"]
[null,null,"Tier 2 = Serious – High Risk"]
[null,null,"Tier 3 = Moderate Risk",null,null,null,null,"MEDIUM"]
[null,null,"Tier 4 = Minor Risk"]
[null,null,"Tier 5 = Negligible Risk",null,null,null,null,"LOW"]
[]
[null,"Probability Codes:",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(23<O32,1,0)","v":0},{"$f":"IF(AND(17<O32,O32<24),1,0)","v":0},{"$f":"IF(AND(14<O32,O32<18),1,0)","v":0},{"$f":"IF(AND(11<=O32,O32<13),1,0)","v":0}]
[null,"Level A","     Likely to impact ecological services and functions quickly and widely in target areas. ",null,null,null,null,null,null,null,null,null,null,{"$f":"IF(23<N32,1,0)","v":0},{"$f":"IF(AND(15<N32,N32<22),1,0)","v":0},{"$f":"IF(AND(16<N32,N32<20),1,0)","v":0},{"$f":"IF(AND(12<=N32,N32<16),1,0)","v":0}]
[null,"Level B","     May impact ecological services and functionsquickly and/or widely in target areas.",null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(16<O32,O32<22),1,0)","v":0},{"$f":"IF(AND(13<O32,O32<18),1,0)","v":0},{"$f":"IF(AND(13<=O32,O32<14),1,0)","v":0},{"$f":"IF(AND(9<O32,O32<11),1,0)","v":0}]
[null,"Level C","     May impact ecological services and functionswidely over time, unlikely to establish quickly.",null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(17<N32,N32<24),1,0)","v":0},{"$f":"IF(AND(16<N32,N32<18),1,0)","v":0},{"$f":"IF(AND(14<=N32,N32<15),1,0)","v":0},{"$f":"IF(AND(10<N32,N32<14),1,0)","v":0}]
[null,"Level D","     Unlikely to impact ecological services and functions quickly or widely over time.",null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(14<O32,O32<16),1,0)","v":0},{"$f":"IF(AND(14<O32,O32<15),1,0)","v":0},{"$f":"IF(AND(10<O32,O32<12),1,0)","v":0},{"$f":"IF(AND(5<=O32,O32<9),1,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(14<N32,N32<18),1,0)","v":0},{"$f":"IF(AND(13<=N32,N32<15),1,0)","v":0},{"$f":"IF(AND(10<N32,N32<12),1,0)","v":0},{"$f":"IF(AND(7<=N32,N32<10),1,0)","v":0}]
[null,"Severity Codes:",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(14<O32,O32<16),1,0)","v":0},{"$f":"IF(AND(10<O32,O32<14),1,0)","v":0},{"$f":"IF(AND(7<=O32,O32<10),1,0)","v":0},{"$f":"IF(AND(5<O32,O32<7),1,0)","v":0}]
[null,"Level I","     Likely to damage coral habitat, species assemblages, or rare/endangered species.",null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(12<=N32,N32<14),1,0)","v":0},{"$f":"IF(AND(9<N32,N32<11),1,0)","v":0},{"$f":"IF(AND(7<=N32,N32<9),1,0)","v":0},{"$f":"IF(AND(5<N32,N32<7),1,0)","v":1}]
[null,"Level II","     Probable to damage coral habitat, species assemblages, or rare/endangered species."]
[null,"Level III","     May damage coral habitat, species assemblages, or rare/endangered species."]
[null,"Level IV","     Unlikely to coral damage habitat, species assemblages, or rare/endangered species."]
[]
[]
[]
[]
[null,null,"Created by Dave Gulko, Division of Aquatic Resources, State of Hawai‘i (2016)"]

{"sheet":"RA Numbers","index":8,"n_rows":53,"n_cols":6,"rows_kept":53,"cut":false,"hidden":true,"merged":[]}
[]
[]
[]
["No",1]
["Fisheries Management Area (FMA)",2,null,null,"IF(E9=\"Fisheries Management Area (FMA), 2, IF(E9=\"Marine Life Conservation District (MLCD)\", 3, IF(E9=\"Marine Refuge, NARS, NWHI Refuge\", 4, IF(E9=\"Ocean Redreation Management Area (ORMA), 2, 1))))"]
["Marine Life Conservation District (MLCD)",3]
["Marine Refuge, NARS, NWHI Refuge",4]
["Ocean Recreation Mangement Area (ORMA)",2]
["Unknown",1]
[]
["Yes",4]
["No",1]
["Unknown",1]
[]
["Criminal",3]
["Civil",2]
["No",1]
["Unknown",1]
[]
[]
["Less than 20 cm",0.5]
["Between 20 cm and 80 cm",1]
["Greater than 80 cm",2]
[]
[]
["ACTION SHOULD BE TAKEN THROUGH THE BLNR"]
["ACTION COULD BE TAKEN THROUGH THE BLNR OR THROUGH ADMINISTRATIVE PENALTY"]
["ACTION SHOULD BE TAKEN THROUGH ADMINISTRATIVE PENALTY"]
[null,null,"Probability"]
["Use OCCL Authorities to go After Restoration Costs Along with Other Recommendations","Severity",">23, >23","22 x 20","20 x 18","16 x 14"]
["Recommend Maximum per Specimen Penalty",null,"20 x 22","18 x 18","16 x 15","14 x 12"]
["Recommend Intermediate per Specimen Penalty",null,"18 x 20","15 x 16","10<12, 10<12","7=<10, 7=<9"]
["Recommend Minimum per Specimen Penalty",null,"14 x 16","9=<11, 10=<14","7=<9, 7=<10","5<7, 5<7"]
[]
["RISK IS HIGH",null,"5, 5.5","15, 14.5","29,26"]
["RISK IS MEDIUM"]
["RISK IS LOW"]
[]
[]
["< 1 Hour",0.5]
["< 1 Day",1]
["< 1 Week",2]
["< 1 Month",3]
["< 1 Year",4]
["Permanent",5]
["Unknown",2]
[]
["Yes",3]
["No",1]
["Unknown",2]
[]
[]
["Consider Using OCCL Authorities to go After Restoration Costs Along with Other Recommendations"]